[
Lists Home |
Date Index |
Thread Index
]
- To: xml-dev@lists.xml.org
- Subject: Some problem working (WAS Re: [xml-dev] Oracle XSQL utility)
- From: Mukul Gandhi <mukul_gandhi@yahoo.com>
- Date: Tue, 2 Aug 2005 21:24:55 -0700 (PDT)
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=YbDGLyDQCdp6w9st7PkpQU4ZVAM5mfoLPLji4cuNLQe5BXGgI683CO/KsLQii8UOaOKQo9OS0PmAWoHd9OBzRXA/3FWJJUptAuauH2zvmW4cBvZ6/vyRRcszlCcksCiRNMeb4Qi2PGTsSDLOLBZxaph8CNbugSK9i087Ls2bpX0= ;
- In-reply-to: <20050802081816.29118.qmail@web32906.mail.mud.yahoo.com>
Hello,
I have had some success working on Oracle XSQL
utility, but now I am facing a different problem and
would appreciate some help. I am using Oracle 8i
database server.
When I give this URL in IE 6
http://localhost:9080/StylesheetProject/hello.xsql,
I get error
-- start of error --
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please
correct the error and then click the Refresh button,
or try again later.
--------------------------------------------------------------------------------
Reference to undeclared namespace prefix: 'xsql'.
Error processing resource
'http://localhost:9080/StylesheetProject/hello.xsq...
<xsql:query>
-- end of error --
The .xsql file is
<?xml version="1.0"?>
<xsql:query xmlns:xsql="urn:oracle-xsql"
connection="demo">
SELECT 'Hello World' AS "GREETING" FROM DUAL
</xsql:query>
Surprisingly namespace declaration seems to be
correct..
Any helps please?
Regards,
Mukul
--- Mukul Gandhi <mukul_gandhi@yahoo.com> wrote:
> I am using Oracle XSQL Servlet provided with Oracle
> 8i
> to generate XML from a database table.
>
> My .xsql file looks like this
> <?xml version="1.0"?>
> <xsql:query xmlns:xsql="urn:oracle-xsql"
> connection="demo">
> SELECT 'Hello World' AS "GREETING" FROM DUAL
> </xsql:query>
>
> The connection demo is configured properly in
> XSQLConfig.xml file.
>
> When I give the following URL on browser
> http://localhost:9080/StylesheetProject/hello.xsql
>
> I get output
> SELECT 'Hello World' AS "GREETING" FROM DUAL
>
> *The query is not getting executed"
>
> Instead following output should appear
> <?xml version = '1.0'?>
> <ROWSET>
> <ROW id="1">
> <GREETING>Hello World</GREETING>
> </ROW>
> </ROWSET>
>
> I am following the article
>
http://www.oracle.com/oramag/oracle/01-jan/o11xml.html
>
> Can somebody tell what could be the problem?
>
> Regards,
> Mukul
>
>
>
> __________________________________
> Yahoo! Mail for Mobile
> Take Yahoo! Mail with you! Check email on your
> mobile phone.
> http://mobile.yahoo.com/learn/mail
>
>
-----------------------------------------------------------------
> The xml-dev list is sponsored by XML.org
> <http://www.xml.org>, an
> initiative of OASIS <http://www.oasis-open.org>
>
> The list archives are at
> http://lists.xml.org/archives/xml-dev/
>
> To subscribe or unsubscribe from this list use the
> subscription
> manager:
> <http://www.oasis-open.org/mlmanage/index.php>
>
>
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
|
