OraFAQ Forum: Forms » PDF upload as an attachment? (3 merged)

Home » Developer & Programmer » Forms » PDF upload as an attachment? (3 merged) (Oracle Form 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PDF upload as an attachment? (3 merged) [message #685311]

Tue, 07 December 2021 05:13

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.

Report message to a moderator

PDF upload as an attachment? [message #685312 is a reply to message #685311]

Tue, 07 December 2021 05:13

Muhammad Rafey
Messages: 6
Registered: December 2021

Junior Member

Report message to a moderator

Re: PDF upload as an attachment? (2 merged) [message #685313 is a reply to message #685311]

Tue, 07 December 2021 05:25

Michel Cadot
Messages: 68315
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

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

Report message to a moderator

PDF upload as an attachment? [message #685314 is a reply to message #685311]

Tue, 07 December 2021 05:30

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.

Report message to a moderator

Previous Topic:	WHEN-BUTTON-PRESSED event issue
Next Topic:	Error 103 in my query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 07 04:07:36 CST 2022