Forums Register Login

ORA-14453- problem while reading the CLOB data

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
could you please post your code where you are reading your clob , and stack trace of your problem

Shailesh
+Pie Number of slices to send: Send
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?
+Pie Number of slices to send: Send
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
That which doesn't kill us makes us stronger. I think a piece of pie wouldn't kill me. Tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 3342 times.
Similar Threads
Error printing out from a read in file.
File reading
problem with Clob
Limit character read using Reader?
transform ClobToString, StringToClob with jdk 1.3
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 08:13:44.