How to File Upload using WebUtil for Each indivisual account?
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'