Oracle PL/SQL a programy OS

[Honza Pazdziora]

On Tue, Jan 11, 2000 at 05:48:24PM +0300, Andrey Lukichev wrote:
> >Dobrý den,
> >nevíte někdo, zda existuje nějaká jiná možnost jak spustit program na
> >úrovni OS (mapř. mail, ls, prostě cokoliv, včetně předání parametrů) z
> >programu v PL/SQL než si toto volání naprogramovat v C a použít jako
> >externí proceduru?
> 
> 
> Hi!
> 
> (Sorry my czech language ;) )
> If i'm right you need to execute on C-written procedure and return results
> to PL/SQL.
> 
> Nema problema:
> Shortly
> 1. you need to write library with your's functions on C and compile it as
> dinamic library.
> 2. grant to user "create library" role
> 3. create library full_path_name_to yours_lib (see Oracle manual)
> 4. create package with interface to C functions.
> That's all.

Well, actually what he wanted was to run an external process. Which
you can do by writing C procedure for that.

------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
   .project: Perl, DBI, Oracle, MySQL, auth. WWW servers, MTB, Spain.
------------------------------------------------------------------------