Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Accessing LOB

Re: Accessing LOB

From: <>
Date: Thu, 20 Mar 2003 14:46:13 +1000
Message-Id: <>

What SQL are you using to access the table that causes the error



Peter McLarty E-mail: Technical Consultant WWW: APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, Australia Mobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048
A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist)
Mincom "The People, The Experience, The Vision"
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. <> Sent by: 12/02/2003 08:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <> cc: Subject: 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 (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: -- Author: < INET: Fat City Network Services -- 858-538-5051 San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: (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
Received on Wed Mar 19 2003 - 22:46:13 CST

Original text of this message