aspose file tools*
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
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
Author

ORA-14453- problem while reading the CLOB data

saravanan kanda swamy
Ranch Hand

Joined: Apr 21, 2004
Posts: 33
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

Joined: Aug 13, 2004
Posts: 1081

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

Shailesh


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

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
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
 
wood burning stoves
 
subject: ORA-14453- problem while reading the CLOB data
 
Similar Threads
Limit character read using Reader?
problem with Clob
Error printing out from a read in file.
File reading
transform ClobToString, StringToClob with jdk 1.3