Re: PL/SQL question

Just a short remark to Janus' original question:

The concept of call-outs from PL/SQL to OS executables is not supported  in Oracle7. The normal way one would go about doing this is to use the DBMS_PIPE server package (installed with ?/rdbms/admin/ catproc.sql). Through pipes created with this package a plsql program could send messages to a listening Pro*C deamon-like program, where each message contains coded embedded instructions to the C program to be performed.

Note: in Oracle8 (released within 7 days) call-outs to e.g. C-programs are directly supported in plsql!

And of course, Gerts proposal is the best! Using the webserver you can use both plsql, cgi and custom developed cartridges - although the latter might be aiming just a little to high for this purpose.

Gert Christiansen wrote:
>
> Janus Christensen wrote:
> >
> > [..]
> > lists). The PL/SQL code should then call the C program which will
> > then put the persons e-mail into the correct files on the mail
 server.
> >
> > Is this possible?
> >
> > Regards,
> > --
> > Janus Christensen Den Kgl. Veterinær- og
 Landbohøjskole
> > e-mail: janus_at_staff.kvl.dk, tel: +45 35 28 23 55, fax: +45 35 28 23
 68
> >
>
> The Oracle WebServer in Oracle 7.3 seems to be the way to go for your
> app.
>
> HTH
>
> --
> Gert Christiansen
> Tel. + 45 45 97 22 11 COWI
> Fax. + 45 45 97 22 12 Consulting Eng. & Planners
> Email gec_at_cowi.dk Parallelvej 15
> DK-2800 Lyngby, Denmark
 

MSc. Bo Stern                         Office: Phone +45 44 80 84 12
Systems Engineer/Technical Analyst            Fax   +45 44 80 80 91
Oracle Denmark A/S                            Email bo_stern_at_iname.com
***************** http://home5.inet.tele.dk/bo_stern *****************
      The statements and opinions expressed here are my own and 
          do not necessarily represent those of my employer.