OraFAQ Forum: JDeveloper, Java & XML » Why this Exception: duration is invalid for this function

Home » Developer & Programmer » JDeveloper, Java & XML » Why this Exception: duration is invalid for this function

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Why this Exception: duration is invalid for this function [message #243647]

Fri, 08 June 2007 03:41

leilss
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

Report message to a moderator

Previous Topic:	Which JDeveloper Version
Next Topic:	Another question: how to free temporary lob when using store procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 22:34:48 CST 2024