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 (TABLESPACE ts_lobs CHUNK 16K PCTVERSION 10); As can be seen in the script, the LOB is stored in a separate tablespace. 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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).