Link to home
Start Free TrialLog in
Avatar of anumoses
anumosesFlag for United States of America

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
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of anumoses

ASKER

images is on the local computer
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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.
In Forms you can use WEBUTIL.Here is a piece of working code:
b_success := webutil_file_transfer.Client_To_DB_with_progress
                                    (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
                                    );
thanks for the very informative help.
thanks