Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: System calls and asynchronized stored procedures?
jListes_at_hotmail.com schrieb:
>
> Hello,
>
> I am a beginning in Oracle development and I want to create an Oracle
> database with some specific features. Indeed, I would like to know if it is
> possible to:
> - Launch asynchronized stored procedures (executing in the background)?
It works with PL/SQL 2.2 and higher with the DBMS_JOB package, see
Server Administrator's Guide,
or enhanced with PL/SQL 8.0 and higher with Oracle Advanced Queuing.
> - Make system calls (call a Shell script, copy files, send mails) from a
> stored procedure?
Would be a nice feature, but I think it works only with a second process via Intersession Communication (see DBMS_PIPE-Package).
>
> Please reply to me (jListes_at_hotmail.com) as well as this newsgroup.
>
> Fred Roast.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
hope this helps
--
Reinhard
E-Mail_at_work: mailto:wahl_at_zv.fhg.de E-Mail_at_home: mailto:ReinhardWahl_at_online.de ----------------------------------------------------Website http://www.online.de/homepages/ReinhardWahl
Hiermit widerspreche ich der Nutzung oder Uebermittlung meiner Daten fuer Werbezwecke oder fuer die Markt- oder Meinungsforschung gemaess Par. 28 Abs. 3 Bundesdatenschutzgesetz.