The moose likes JDBC and the fly likes ORA-14453- problem while reading the CLOB data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ORA-14453- problem while reading the CLOB data" Watch "ORA-14453- problem while reading the CLOB data" New topic

ORA-14453- problem while reading the CLOB data

saravanan kanda swamy
Ranch Hand

Joined: Apr 21, 2004
Posts: 33

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

Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

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


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

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?

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
saravanan kanda swamy
Ranch Hand

Joined: Apr 21, 2004
Posts: 33

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

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

I agree. Here's the link: http://aspose.com/file-tools
subject: ORA-14453- problem while reading the CLOB data
Similar Threads
problem with Clob
transform ClobToString, StringToClob with jdk 1.3
Error printing out from a read in file.
File reading
Limit character read using Reader?