XSQL Query returns empty rowset

hi

I wrote the following xsql query: info.xsql

<?xml version="1.0"?>
<xsql:query xmlns:xsql="urn:oracle-xsql" connection="hele">
SELECT * FROM T_Order
</xsql:query>

The table T_Order contains 6 records:

The result of the query is an empty rowset:

<?xml version = '1.0'?>
<ROWSET/>

I got no idea what is wrong - connection is set up, using sql plus worksheet the query works.

environment:

    Oracle Web Server (the 9i build in server)     Oracle 9i Database

Thanks

Dietmar Received on Sat Jan 19 2002 - 08:04:09 CST