I am doing a XSQL Query but when I view the xsql file in the browser, the query results (ROWSET ROWS) do not show anything but the query parameters. The code is:
<?xml version="1.0" encoding="UTF-8" ?>
<my-page connection="proddy_oracle_password" xmlns:xsql="urn:oracle-xsql">
<xsql:query>SELECT * FROM proddy.proddy_table ORDER BY id</xsql:query>
Any ideas, my connections seem OK with Tomcat, Oracle and MySql are seem to be working fine. Any help would be most welcome. Thanks in advance.