java.sql.SQLException: ORA-00604: in BFILE.fileExists
Srividya Ramkumar
Greenhorn
Joined: Jul 10, 2002
Posts: 3
posted
0
I am attempting to use BFILE columns to reference existing files on a windows 2000. I have created a "DIRECTORY" and given the directory READ permissions to public. I can update the BFILE column in the database but when I attempt to see if the file exists I get an error.
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01460: unimplemented or unreasonable conversion requested ORA-06512: at "SYS.DBMS_LOB", line 456 ORA-06512: at line 1 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1898) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:407) at oracle.sql.LobPlsqlUtil.plsql_fileExists(LobPlsqlUtil.java:755) at oracle.jdbc.dbaccess.DBAccess.fileExists(DBAccess.java:898) at oracle.sql.LobDBAccessImpl.fileExists(LobDBAccessImpl.java:244) at oracle.sql.BFILE.fileExists(BFILE.java:213)