| Insert SQL--- LONG datatype.. [message #382743] |
Sat, 24 January 2009 00:20  |
sanjeev.sharda
Messages: 17
Registered: December 2008
Location: Ludhiana
|
Junior Member |
|
|
hello friends.. i hv create a table itemdb_images in Oracle 9i which desc.. blow.. i store images for items in this table... i want to copy a record to new item using select.. i m getting the error ..... illegal use of LONG datatype..
i use this sql
INSERT INTO itemdb_IMAGEs(doc_pk,item_code,doc_scanned_copy,file_name,file_extension,USER_INSERT,DATE_INSERT,USER_EDIT,DATE_EDIT)
SELECT itemdb_images_pk.NEXTVAL,6,doc_scanned_copy,file_name,file_extension,'ADMIN', SYSDATE,'Admin', SYSDATE
FROM itemdb_images
WHERE ITEM_CODE=5;
item_code=5 is my old item which saved alreadyin table and now i m copy into new item_code=6
Please help me how can i insert data...
desc itemdb_images
DOC_PK NOT NULL NUMBER(15)
ITEM_CODE NOT NULL NUMBER(10)
DOC_SCANNED_COPY NOT NULL LONG RAW
FILE_NAME NOT NULL VARCHAR2(50)
FILE_EXTENSION NOT NULL VARCHAR2(4)
USER_INSERT NOT NULL VARCHAR2(10)
DATE_INSERT NOT NULL DATE
USER_EDIT NOT NULL VARCHAR2(10)
DATE_EDIT NOT NULL DATE
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
