mail on forms

[kriss]

Can anybody tell me just how I could send mail from Oracle Developer 2000 Forms?
I have tried locating the mailx package from all my libraries but cannot find it.This was recommended to me from one of the forums on tek-tips.
Any help?.

Kriss

 

[smoriano]

You can try by including library d2kwutil.pll (to use this you need d2kwutil.dll, that doesn't work on windows2000), wich is included in forms.

Then your code to send an email (without atachment) will be like this:

declare
destinatarios varchar2(100):='null@null.null';
var1 varchar2(100)='test subject';
var2 varchar2(100)='test';

BEGIN
WIN_API_SHELL.WINEXEC('C:\iexplore.exe '||' /MAILURL:MAILTO:'||destinatarios||'?cc='||' '||'&subject='||var1||'&body='||var2,WIN_API.SW_SHOWNORMAL,TRUE);
END;

Hope this helps

 

[kriss]

Gracias smoriano,
It actually worked !!
However I got one more lil' problem.
When I try inserting a space beteween two texts for example 'test subject', it gives me a blank .But if I put 'testsubject' this is accepted. Is there any special charater I should use to signify a preceeding space ??
Kriss