Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » how to "Create a Form to Upload Spreadsheet File" (Orace database 10g Express Edition,Windows)
how to "Create a Form to Upload Spreadsheet File" [message #379562] Wed, 07 January 2009 00:58
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

Dear experts,

i have created an application to "upload spreadsheet data" in the database table. but i can't create "upload spreadsheet File". that means i can upload data by copying data from spreadsheet and directly paste in my form text box. then pressing sumbit button its working. But if i want to select only the file instead of copy the file content (as we do in email attachment)not working.

"for copy and paste" uploading my process code was as:
process_upload.process_cars(:P1_UPLOAD, :P1_UPLOAD);

(Here P1_UPLOAD is the text where i am pasting data)--its working successfully.

For file upload i did the same process. I used "File Borwse" named P1_UPLOADFILE instead of text box. process code:
process_upload.process_cars(:P1_UPLOADFILE , :P1_UPLOADFILE );

please help me
Kamal hossain
Previous Topic: Apex on existing Oracle DB
Next Topic: How to Customize The Mod_Plsql Error Page
Goto Forum:

Current Time: Wed Aug 10 06:09:11 CDT 2022