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