Oracle Forms (MOSC)

MOSC Banner

How to File Upload using WebUtil for Each indivisual account?

edited Sep 2, 2010 5:49AM in Oracle Forms (MOSC) 1 commentAnswered
 I am uploading files for my individual accounts. Each account can have one to multiple files (.pdf, .docx, .txt etc)

My Table Structure:-

CREATE TABLE  ST_ATTACHMENT_ACCOUNT
       ( ID                                        NUMBER,
         ACCOUNT_CDE              NUMBER(8,0)  NOT NULL,
         FILE_NAME                      VARCHAR2(100),
         FILE_BLOB                       BLOB)
TABLESPACE PRODTABLES;

the Upload code I have:-

ls_full_filename := WEBUTIL_FILE.FILE_OPEN_DIALOG('c:\','*.*','|All Files|*.*|','Upload Document for Account');

lb_success := webutil_file_transfer.Client_To_DB_with_progress
                                    (clientFile      => ls_full_filename
                                    ,tableName       => 'ST_ATTACHMENT_ACCOUNT'
                                    ,columnName      => 'FILE_BLOB'
                                    ,whereClause     => 'ID = 1'   
                                    ,progressTitle   => 'Upload to Database in progress'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center