ORA-14453- problem while reading the CLOB data

[saravanan kanda swamy]

Hi,

I am trying to read the CLOB data using the BufferReader. But sometimes it gives an error saying unable to read the CLOB data.


The Code I have used as follows:

StringBuffer strData = new StringBuffer();
Reader reader = clobData.getCharacterStream();
BufferedReader bReader = new BufferedReader(reader);

String strLine = new String();
while ( (strLine = bReader.readLine()) != null)
{
strData.append(strLine + "\n");
}
return strData.toString();

I am getting an error while reading the CLOB data.

java.io.Exception:java.sql.SQLException: ORA-14453

I am using weblogic 6.1 and using weblogic oracle drivers. The oracle version is 9i.

I am not able to find the cause of the problem. Please guide me how to resolve this error.

Thanks in advance

Regards,
Saravanan.K

[Shailesh Chandra]

could you please post your code where you are reading your clob , and stack trace of your problem

Shailesh

[Paul Sturrock]

ORA-14453 means you are attempting to use a LOB field on a temporary table that has been purged. Are you trying to get data from a temporary table?

[saravanan kanda swamy]

Hi,

I am calling a procedure in a package using weblogic driver class. In that procedure I am closing all the other connections of oracle. After that I am executing this procedure.

weblogic.jdbc.common.OracleCallableStatement - class

OracleCallableStatement calstmtObject
(OracleCallableStatement)getConnection().prepareCall(strProcQuery);

and then I am doing this:

calstmtObject.registerOutParameter(1, Types.VARCHAR);
calstmtObject.registerOutParameter(2, Types.VARCHAR);
calstmtObject.registerOutParameter(3, Types.CLOB);
calstmtObject.registerOutParameter(4, Types.DATE);

all are out parameters in reading the clob data i am getting this error.

Clob clobData = calstmtObject.getClob(3);

and then I am passing that clob object to the separate function which will read and give the values in string.

But sometimes while reading this value in the function where I am getting the String value

I am getting this error.

java.io.IOException: Error in getLobStringValue java.sql.SQLException: ORA-14453:

at weblogic.db.oci.OciClobCharStream.read(OciLobReader.java:265)
at weblogic.db.oci.OciLobReader.read(OciLobReader.java:161)
at java.io.BufferedReader.fill(BufferedReader.java:134)
at java.io.BufferedReader.readLine(BufferedReader.java:294)
at java.io.BufferedReader.readLine(BufferedReader.java:357)

only some times I am getting this error.

But I am not able to find out the reason.

Thanks in advance

Regards,
Saravanan.K