Home » Developer & Programmer » JDeveloper, Java & XML » Why this Exception: duration is invalid for this function
Why this Exception: duration is invalid for this function [message #243647] Fri, 08 June 2007 03:41
Messages: 2
Registered: June 2007
Junior Member
I want to create a temporary BLOB like this:

oracle.sql.BLOB tempBlob = oracle.sql.BLOB.createTemporary(conn, false,oracle.sql.BLOB.DURATION_SESSION);

but if I use the oracle.sql.BLOB.DURATION_CALL duration type, I got such exception:

java.sql.SQLException: 持续时间对于此函数无效
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.T4C8TTIBlob.createTemporaryLob(T4C8TTIBlob.java:97)
at oracle.jdbc.driver.T4CConnection.createTemporaryBlob(T4CConnection.java:1621)
at oracle.sql.BLOB.createTemporary(BLOB.java:534)

Oracle Server and Driver is: 10.0.1

Can you help me? with many thanks
Previous Topic: Which JDeveloper Version
Next Topic: Another question: how to free temporary lob when using store procedure
Goto Forum:

Current Time: Mon Jul 24 08:15:49 CDT 2017

Total time taken to generate the page: 0.11433 seconds