retrieving CLOBs through Java/Oracle with package functions

From: Tony Cantara <tonycantara123_at_hotmail.com>
Date: 22 Jan 2003 09:47:45 -0800
Message-ID: <3d0c2563.0301220947.759cfe0e@posting.google.com>

jdk1.3, Win2K, Oracle8i enterprise.

All, have a bit of a problem, details below. Any relevant thoughts?
Tony.

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); Connection conn=DriverManager.getConnection("jdbc:oracle:oci8:@dbtest","scott","tiger");

PreparedStatement stmt=conn.prepareStatement("SELECT C$GFXLUTL1.UtlParse.GetXML(blobfile) AS tony1 FROM tblblobtests WHERE blobid=?");
stmt.setString(1,"A10042");
ResultSet rset=stmt.executeQuery;

I get the following error trace.

java.sql.SQLException: ORA-00904: invalid column name

        void oracle.jdbc.dbaccess.DBError.throwSqlException(java.lang.String, java.lang.String, int)

		DBError.java:168
	int oracle.jdbc.oci8.OCIDBAccess.check_error(int,
oracle.jdbc.oci8.OCIDBStatement)
		OCIDBAccess.java:1597
	oracle.jdbc.dbaccess.DBColumn[]

oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(oracle.jdbc.dbaccess.DBStatement, byte[], oracle.jdbc.dbaccess.DBDataSet)

		OCIDBAccess.java:798
	void oracle.jdbc.driver.OracleStatement.doExecuteQuery()
		OracleStatement.java:1674
	void oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout()
		OracleStatement.java:1870
	java.sql.ResultSet oracle.jdbc.driver.OracleStatement.executeQuery(java.lang.String)
		OracleStatement.java:538

When I execute "SELECT SELECT C$GFXLUTL1.UtlParse.GetXML(blobfile) AS tony1 FROM tblblobtests WHERE blobid='A10042'" from within SQL/Plus, I get the expected result without errors. When I omit the "AS tony1" in the Java source, same error. Received on Wed Jan 22 2003 - 11:47:45 CST