BLOB Insert problem

From: Nirmalya Das <nirmalya_at_hln.com>
Date: Thu, 7 Sep 2006 12:50:10 -0700
Message-ID: <20060907125010.ahmowcs8w0sskok4@www.hln.com>

Trying to insert data in the "DATA" column through OCI.

The problem is in one instance this only stores if the length is 3964 characters or less. The same application code can store bigger objects in another database.

The two databases are identical and the table structure given below is also identical.

Trying to find an answer. Don't know where else or what else to look for.

Here's the table structure

CREATE TABLE MEGA_OWNER_01.BLOBSTORE
(

    CNY#     NUMBER(8)    NOT NULL,
    RECORD#  NUMBER(8)    NOT NULL,
    PARENTID VARCHAR2(60) NOT NULL,
    TYPE     VARCHAR2(30) NOT NULL,
    DATA     BLOB             NULL,
    STATUS   CHAR(1)      DEFAULT 'T'     NULL,

    CONSTRAINT FK_BLOBSTORE_CNY
    FOREIGN KEY (CNY#)
    REFERENCES MEGA_OWNER_01.COMPANY (RECORD#)     ON DELETE CASCADE
    DEFERRABLE ENABLE
)
LOB(DATA) STORE AS LOBD_BLOBSTORE_DATA
(

    TABLESPACE ACCTLOB
    STORAGE(INITIAL 5120K NEXT 5120K MINEXTENTS 1 MAXEXTENTS UNLIMITED             PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)     DISABLE STORAGE IN ROW
    NOCACHE
    NOLOGGING
    CHUNK 8192
    PCTVERSION 10
)
TABLESPACE ACCTDATA
LOGGING
PCTFREE 10
PCTUSED 0
INITRANS 1
MAXTRANS 255
STORAGE(BUFFER_POOL DEFAULT)
NOPARALLEL
NOCACHE TIA, Nirmalya

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 07 2006 - 14:50:10 CDT