Re: Accessing LOB
What SQL are you using to access the table that causes the error Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +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. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2003 08:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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_typeVARCHAR2(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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
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_typeVARCHAR2(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, CONSTRAINTfk_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).
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_typeVARCHAR2(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, CONSTRAINTfk_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).
