[
Lists Home |
Date Index |
Thread Index
]
- To: xml-dev@lists.xml.org
- Subject: Oracle XSQL utility
- From: Mukul Gandhi <mukul_gandhi@yahoo.com>
- Date: Tue, 2 Aug 2005 01:18:16 -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=4sCIRyk01s3Vrzgn7H28smsAJcJfcWTzWNbCD5gGslHTrP4ZtFohZiJ5vQxitIfoD+xxMP5v4G5Nk8SurzsENCZUG0K3DEWjg3Eaorg8uDnjEpnFIqXqX7JsR6l4+CK7c6Vj1mz94Tl0mkXsWH+DlGYVqybSKi6FiCe+vJgmRh0= ;
- In-reply-to: <1122968288.42ef22e062711@horde.scannet.dk>
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
|
