Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Upload File Using Form Wizard

vitodcNov 16 2005 — edited Nov 17 2005
Hi,

I have completed the how-to on upload and downloading files from the documentation.
I have a custom table that I would like to use to store the image along with other values.
I create a form using the Form and Report wizard in htmldb 2.0.

I am having problems when it comes to changing where the image is upload, HTMLDB_APPLICATION_FILES to custom table.
<code>
IF ( :P2_FILE_NAME is not null ) THEN
INSERT INTO file_subjects(id,NAME, SUBJECT, BLOB_CONTENT, MIME_TYPE)
SELECT ID,:P2_FILE_NAME,:P2_SUBJECT,blob_content,mime_type
FROM HTMLDB_APPLICATION_FILES WHERE name = :P2_FILE_NAME;
DELETE from HTMLDB_APPLICATION_FILES WHERE name = :P2_FILE_NAME;
END IF;
</code>

I know it works fine if I create the page manually, but then I need to create insert, update, delete and cancel processes; all of which the wizard can handle.

Is there a better solution?

Thanks
VC
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2005
Added on Nov 16 2005
6 comments
329 views