Oracle Forms (MOSC)

MOSC Banner

File Upload NOT showing no record....

edited Sep 2, 2010 5:53AM in Oracle Forms (MOSC) 1 commentAnswered
 Using Forms 10g and Webutil. I am uploading my file using the following code. The Status shows file upload is Successful.. but NO Record exists in the Table...!

Here is my Table Structure:-

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

Here is my code:-

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

    last_record;
    :ACCOUNT_ATTACHMENT.TITLE := ls_filename;
 
 INSERT INTO ST_ATTACHMENT_ACCOUNT (ACCOUNT_CDE, FILE_BLOB)
    VALUES (:ACCOUNTS_DETAIL.ACCOUNT_CDE, NULL);
 
  l_success := webutil_file_transfer.Client_To_DB_with_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