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

Oracle XSQL utility

• To: xml-dev@l...
• Subject: Oracle XSQL utility
• From: Mukul Gandhi <mukul_gandhi@y...>
• 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@h...>

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 

• Follow-Ups:
  • Some problem working (WAS Re: Oracle XSQL utility)
    • From: Mukul Gandhi <mukul_gandhi@y...>

• References:
  • a useful naming convention
    • From: Bryan Rasmussen <bry@i...>

• Prev by Date: Re: a useful naming convention
• Next by Date: SV: a useful naming convention
• Previous by thread: RE: a useful naming convention
• Next by thread: Some problem working (WAS Re: Oracle XSQL utility)
• Index(es):
  • Date
  • Thread