Home » Developer & Programmer » Forms » PDF upload as an attachment? (3 merged) (Oracle Form 12c)
icon1.gif  PDF upload as an attachment? (3 merged) [message #685311] Tue, 07 December 2021 05:13 Go to next message
Muhammad Rafey
Messages: 6
Registered: December 2021
Junior Member
How can i upload a local file of .pdf format using button?
i've tried this this shown below but shows error of load_file must be declare.

Code in when-button-pressed trigger:

Declare
a varchar2 (1000);
x number;

begin
select substr(:file_name,33)
into a from dual;
LOAD_FILE(a); --------------------------> Error201 identifier "load_file" must be declared.
x := show_alert('upload');

exception
when others then
Message('File upload Fail');
Message('File upload Fail');
end;

Is this the correct way?
Or can you guide which is the right way.
icon1.gif  PDF upload as an attachment? [message #685312 is a reply to message #685311] Tue, 07 December 2021 05:13 Go to previous messageGo to next message
Muhammad Rafey
Messages: 6
Registered: December 2021
Junior Member
How can i upload a local file of .pdf format using button?
i've tried this this shown below but shows error of load_file must be declare.

Code in when-button-pressed trigger:

Declare
a varchar2 (1000);
x number;

begin
select substr(:file_name,33)
into a from dual;
LOAD_FILE(a); --------------------------> Error201 identifier "load_file" must be declared.
x := show_alert('upload');

exception
when others then
Message('File upload Fail');
Message('File upload Fail');
end;

Is this the correct way?
Or can you guide which is the right way.
Re: PDF upload as an attachment? (2 merged) [message #685313 is a reply to message #685311] Tue, 07 December 2021 05:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68094
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please post your Forms questions in Forms forum not in SQL one.

icon1.gif  PDF upload as an attachment? [message #685314 is a reply to message #685311] Tue, 07 December 2021 05:30 Go to previous message
Muhammad Rafey
Messages: 6
Registered: December 2021
Junior Member
How can i upload a local file of .pdf format using button?
i've tried this this shown below but shows error of load_file must be declare.

Code in when-button-pressed trigger:

Declare
a varchar2 (1000);
x number;

begin
select substr(:file_name,33)
into a from dual;
LOAD_FILE(a); --------------------------> Error201 identifier "load_file" must be declared.
x := show_alert('upload');

exception
when others then
Message('File upload Fail');
Message('File upload Fail');
end;

Is this the correct way?
Or can you guide which is the right way.
Previous Topic: WHEN-BUTTON-PRESSED event issue
Next Topic: Error 103 in my query
Goto Forum:
  


Current Time: Thu Jan 27 16:53:08 CST 2022