Re: Send E-mail from PL/SQL

You can do a external procedure call on NT. Windows Developer Journal has a basic sendmail DLL which will send a file. (June 1998 Volumne 9, #6) I think you can get the source at www.wdj.com

Use the shell below to setup your libraries etc..

    Thanks,

        John

• External Library shell
• 05/14/98 John F. Keaveney --
• create an exernal library reference

prompt Creating Library...

create or replace library MyLibrary as 'mylibrary.dll' ;

/
show err
/

• Declare the package

prompt Declaring Package ...

create or replace package MyPackage

function MyFunction( param1 string ) return number ;

pragma restrict_references( MyFunction, wnds, rnds, wnps, rnps ) ;

end;

/
show err
/

• Create the package

prompt Creating Package ...

create or replace package body MyPackage as

• Create the wrapper function

function MyFunction( param1 string ) return number is

 external library MyLibrary

 name "MyDLLFunction"

 language C

 parameters ( param1 string ) ;

end MyPackage ;

/
show err
/

Karsten Weikop wrote in message <35FD7135.8FCE63A8_at_isa.dknet.dk>...
>I'm using Oracle Web Application Server 3.0. I use the PL/SQL cartridge
>and want to send a E-mail from within a package/procedure tyo a POP3
>server.
>
>Is there any way to do this?
>
>I'm using Sun Solaris on Sparc or Intel.
>
>
>Thanks in advance
>
>Karsten Weikop
>Make IT
>Denmark
>
>E-mail: karsten_at_weikop.dk
>Phone: +45 26 16 06 06
Received on Mon Sep 14 1998 - 00:00:00 CDT