>Archive Index
>xml-dev Archive Home
>Recent entries

>Thread Prev - a useful naming convention
>Thread Next - Some problem working (WAS Re: [xml-dev] Oracle XSQL utility)

Oracle XSQL utility

From: Mukul Gandhi <mukul_gandhi@-----.--->
To: xml-dev@-----.---.---
Date: 8/2/2005 8:18:00 AM

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

>Thread Prev - a useful naming convention
>Thread Next - Some problem working (WAS Re: [xml-dev] Oracle XSQL utility)

>Archive Index
>xml-dev Archive Home
>Recent entries

Altova Mailing List Archives

Oracle XSQL utility