OraFAQ Forum: Programming Interfaces » temp tablespace becomes full, not released by JDBC thin client ojdbc14.jar

Home » Open Source » Programming Interfaces » temp tablespace becomes full, not released by JDBC thin client ojdbc14.jar (Oracle 10g ,Sunsolaris /windows XP )

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

temp tablespace becomes full, not released by JDBC thin client ojdbc14.jar [message #418573]

Mon, 17 August 2009 07:14

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.
ora-1652 error
Thanks.

Report message to a moderator

[Message index]

		temp tablespace becomes full, not released by JDBC thin client ojdbc14.jar By: pashish80 on Mon, 17 August 2009 07:14
		Re: temp tablespace becomes full, not released by JDBC thin client ojdbc14.jar By: Kevin Meade on Sat, 26 September 2009 01:20

Previous Topic:	Copying Blob data from one database to another database
Next Topic:	ORA-22835 error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 01:59:04 CDT 2024