Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

ORA-14453- problem while reading the CLOB data

 
saravanan kanda swamy
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
could you please post your code where you are reading your clob , and stack trace of your problem

Shailesh
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!