← Prev in month ← Prev in thread
Next in thread → Next in month →

Oracle XSQL utility

From
Mukul Gandhi <>
To
Date
2005-08-02T08:18:16Z
ID
<>
Thread
Oracle XSQL utility
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
← Prev in month ← Prev in thread
Next in thread → Next in month →