Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Accessing LOB
Friends,
Find below the script of a table with a CLOB datatype
CREATE TABLE lob_content_display
( content_display_id VARCHAR2(30),
business_id VARCHAR2(30), language_id VARCHAR2(30), content_type VARCHAR2(30), detail CLOB DEFAULT EMPTY_CLOB(), CONSTRAINT pk_lob_cont_dsp PRIMARY KEY (content_display_id, business_id, language_id,content_type) USING INDEX TABLESPACE indx, CONSTRAINT fk_clcd_contdsp_bsl_ct FOREIGN KEY (content_display_id, business_id, language_id,content_type) REFERENCES content_display(content_display_id,business_id, language_id, content_type) )LOB (detail) STORE AS
I am able to access the data in all the columns except the 'detail' column. Oracle throws an error - 'ORA-03120: two-task conversion routine: integer overflow' when the mentioned column is accessed.
The oracle documentation says :
ORA-03120: two-task conversion routine: integer overflow
Cause: An integer value in an internal Oracle structure overflowed when being sent or received over a heterogeneous connection. This can happen when an invalid buffer length or too great a row count is specified. It usually indicates a bug in the user application.
Action: Check parameters to Oracle calls. If the problem recurs, reduce all integer parameters, column values not included, to less than 32767.
Please let me know how to solve this problem. Should I change any of the parameters in the init.ora file.
Regards,
Narasimhan
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <narasimhan.thotapalli_at_iflexsolutions.com INET: narasimhan.thotapalli_at_iflexsolutions.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Feb 12 2003 - 04:33:51 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).