How to insert data into the BLOB column
664039Feb 5 2010 — edited Mar 31 2010Hi All,
Can anyone help me to insert data into the BLOB data type column?
The table structure is
CREATE TABLE XXATFL_DM_FORCAST_STG
(
TASK_ID NUMBER,
USER_ID NUMBER,
CREATED_BY NUMBER(15),
CREATION_DATE DATE,
LAST_UPDATED_BY NUMBER(15),
LAST_UPDATE_DATE DATE,
LAST_UPDATE_LOGIN NUMBER(15),
RECORD_STATUS VARCHAR2(1 BYTE),
ERROR_MESSAGE VARCHAR2(4000 BYTE),
DATA_FILE BLOB
)
I want to insert data in the DATA_FILE column. and this insert statement will in inside a procedure.
Please help me as soon as possible as this is very urgent for me
Thanks & Regards,
Chandan