Re: Is it possible to call a C program from a stored procedure?

robert.goodwin_at_msfc.nasa.gov (Robert Goodwin) wrote: >In article <4chqt1$p3o_at_chopin.bcit.bc.ca>, lenka@ (Benjamin Yu) wrote:
>>I need to call an external program from a stored procedure in Oracle 7.1.
 Can
>>this be done?

 From my understanding you can do that using SQL*Module, that is available in Oracle 7.1.6, I don't know about previous versions. I have never used it but I know it introduces a PL/SQL pragma (coming straight from ADA ...) allowing you to define the calling sequence for a procedure/function and the language in which it is written. I have no idea anyway on how it is then implemented.

  CIAO    Renato

-- 

Renato Brazioli      Sodalia SpA              e-mail: brazioli_at_sodalia.it
                     Via del Brennero, 364    voice:  +39(461)316.154 (direct)
                     I-38100 Trento           fax:    +39(461)316.127
                     ITALY