This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes java.sql.SQLException: ORA-00604: in BFILE.fileExists Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "java.sql.SQLException: ORA-00604: in BFILE.fileExists" Watch "java.sql.SQLException: ORA-00604: in BFILE.fileExists" New topic

java.sql.SQLException: ORA-00604: in BFILE.fileExists

Srividya Ramkumar

Joined: Jul 10, 2002
Posts: 3
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(
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
at oracle.jdbc.driver.OraclePreparedStatement.execute(
at oracle.sql.LobPlsqlUtil.plsql_fileExists(
at oracle.jdbc.dbaccess.DBAccess.fileExists(
at oracle.sql.LobDBAccessImpl.fileExists(
at oracle.sql.BFILE.fileExists(
I agree. Here's the link:
subject: java.sql.SQLException: ORA-00604: in BFILE.fileExists
It's not a secret anymore!