anumoses
asked on
Load images to oracle table.
Is there any process to load jpeg images into oracle database using a procedure ? The database column will be a blob. I googled, but could not find any that I can use.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
When you mentioned procedure I was thinking an Oracle Stored Procedure. Those cannot access a remote file system.
You will need some program running on that computer. I believe SQL Loader can handle BLOBs but I've never tried.
You ask a lot of Forms questions: You should be able to upload the image using forms and process it from there. Might be a simple insert statement from Forms.
You will need some program running on that computer. I believe SQL Loader can handle BLOBs but I've never tried.
You ask a lot of Forms questions: You should be able to upload the image using forms and process it from there. Might be a simple insert statement from Forms.
In Forms you can use WEBUTIL.Here is a piece of working code:
b_success := webutil_file_transfer.Clie nt_To_DB_w ith_progre ss
(clientFile => :BC_FILE.S_FILE_NAME
,tableName => MY_TABLE'
,columnName => 'B_FILE' --blob
,whereClause => 'N_ATTACH_ID = '||X_N_ID -- PK
,progressTitle => 'Upload to Database in progress'
,progressSubTitle=> 'Please wait'
,asynchronous => false
,callbackTrigger => null
);
b_success := webutil_file_transfer.Clie
(clientFile => :BC_FILE.S_FILE_NAME
,tableName => MY_TABLE'
,columnName => 'B_FILE' --blob
,whereClause => 'N_ATTACH_ID = '||X_N_ID -- PK
,progressTitle => 'Upload to Database in progress'
,progressSubTitle=> 'Please wait'
,asynchronous => false
,callbackTrigger => null
);
ASKER
thanks for the very informative help.
ASKER
thanks
ASKER