Home » Developer & Programmer » JDeveloper, Java & XML » temp tablespace becomes full, not released by JDBC thin client ojdbc14.jar (oracle 10g, jdk1.5,sun solaris/windows )
temp tablespace becomes full, not released by JDBC thin client ojdbc14.jar [message #418548] Mon, 17 August 2009 04:33 Go to next message
pashish80
Messages: 4
Registered: May 2008
Location: Mumbai
Junior Member
Hi ,

our java web application calls a stored procedure every 10 seconds or so , it has an output parameter of type clob.
PROCEDURE PR_GET_MKT_DATA
(
pi_LIST IN VARCHAR2,
po_RETSTR OUT CLOB
);

This is called using prepared statement,

java.sql.clob (ojdbc14.jar) is used (oracle 10g)
--------------------------------------------------------------------------------
clob.getSubString(arg0, arg1) to retrieve the data.

The issue faced is that the temp tablespace becomes full, not released by JDBC thin client.

Thanks.
Re: temp tablespace becomes full, not released by JDBC thin client ojdbc14.jar [message #418608 is a reply to message #418548] Mon, 17 August 2009 11:47 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
You seem to have concluded that you know the cause of it, since you provide us with something close to nothing.
I would say log a bug in Metalink, or rephrase your question and give some info we can actually use.
Previous Topic: EJB JSF Data Controller - jndi.properties remote server error
Next Topic: Message Internal Error: Inconsistent catalog view
Goto Forum:
  


Current Time: Thu Mar 28 18:50:39 CDT 2024