Re: retrieving CLOBs through Java/Oracle with package functions

for starters, I believe you need to use a table alias when working with object and user defined types, like:

"SELECT a.C$GFXLUTL1.UtlParse.GetXML(blobfile) AS tony1 FROM blblobtests a WHERE a.blobid=?"

--Peter

Tony Cantara wrote:
> 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:55:33 CST