| error during creation of send mail procedure [message #74038] |
Sun, 29 August 2004 03:32  |
Kumar Iyer
Messages: 12
Registered: August 2004
|
Junior Member |
|
|
while executing the
sending mail from host command procedure,
it gives the error
The procedure begins here
PROCEDURE SendMail(to IN varchar2, subject IN varchar2, body IN varchar2) IS
UserInterface varchar2(40) := get_application_property(USER_INTERFACE);
MailTo varchar2(2000) := 'mailto:'||to||'?subject='||subject||'&body='||body;
BEGIN
if UserInterface = 'MSWINDOWS32' then
host('cmd /C start '||MailTo, NO_SCREEN);
elsif UserInterface like '%WIN' then
host('command /C start '||MailTo, NO_SCREEN);
elsif UserInterface in ('MOTIF', 'X') then
host('echo "'||body||'" | mailto '||to||' -s "'||subject||'"', NO_SCREEN);
elsif UserInterface = 'WEB' then
WEB.show_document(MailTo, '_BLANK');
end if;
END;
Error during creation of procedure
variable :get_application_property must be declared
Pl tell me where to declare the variable
Kumar
|
|
|
|
|
|
| Re: error during creation of send mail procedure [message #74047 is a reply to message #74043] |
Mon, 30 August 2004 18:58  |
Kumar Iyer
Messages: 12
Registered: August 2004
|
Junior Member |
|
|
yes,i was wrong actually it applies for forms.
but now the procedure does gets executed but,
at the end ,it does not send the mail automatically,as user interaction is necessary to send it.
i.e i have to click on send button as the cursor stays over there
Pl help
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
