Oracle-L: Accessing LOB

From: <narasimhan.thotapalli_at_iflexsolutions.com>
Date: Wed, 12 Feb 2003 02:33:51 -0800
Message-ID: <F001.0054A6BF.20030212023351@fatcity.com>

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: <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-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).

Received on Wed Feb 12 2003 - 04:33:51 CST