Re: PL/SQL question

Janus Christensen wrote:
>
> Hello.
>
> I am in the process of producing a database application which, uses
> a database that contains information about Ph.D. students at the
> Royal Veterinarian and Agricultural School in Denmark. This database
> also contains information about several mailing lists. The idea is
> that the users should be able to access the mailing lists via a web
> browser and be able search for mailing lists and people on the lists.
>
> Another feature that is giving me some problems is that people should
> be able to put and remove themselves from the mailing lists using
> the web application. Said application would be written in PL/SQL.
> This is my question: is it possible to call a program from PL/SQL?
> This program would probably written in C and does the actual
> maintaining of the mailing lists by writing in files which reside on
> the mailing server. These files contains the information about who
> is on which mailing lists.
>
> This means: when a person is inserted into the database a number of
> triggers fire and inserts the person in the default groups (mailing
> 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
>
> ---------------------------------------------------------------
>
> Name: vcard.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Janus Christensen

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