[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Some problem working (WAS Re: Oracle XSQL utility)

• To: xml-dev@l...
• Subject: Some problem working (WAS Re: Oracle XSQL utility)
• From: Mukul Gandhi <mukul_gandhi@y...>
• 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@w...>

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@y...> 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 
 

• References:
  • Oracle XSQL utility
    • From: Mukul Gandhi <mukul_gandhi@y...>

• Prev by Date: Re: Simple XPath question
• Next by Date: RE: Simple XPath question
• Previous by thread: Oracle XSQL utility
• Next by thread: RE: a useful naming convention
• Index(es):
  • Date
  • Thread