Re: running external programs
km <km@mrna.tn.nic.in> schrieb:
Hi all,
Is it possible in a PLSQL function to call an external program/script residing at /usr/bin and return the result ?
No, because plsql is a trusted language.
You can't run external commands from such a language.
are there any workarounds for this sort of a problem ?
Yes, with untrusted languages like plperlU or plsh or other.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082�, E 13.56889�
Import Notes
Reply to msg id not found: 20061107183853.GA2608@mrna.tn.nic.inReference msg id not found: 20061107183853.GA2608@mrna.tn.nic.in
In response to Andreas Kretschmer <akretschmer@spamfence.net>:
are there any workarounds for this sort of a problem ?
Yes, with untrusted languages like plperlU or plsh or other.
You can also write your own stored procedures that duplicate the
functionality of the external program ... assuming you have that
kind of access to the source code of the external program.
--
Bill Moran
Collaborative Fusion Inc.
IMPORTANT: This message contains confidential information and is intended only for the individual named. If the reader of this message is not an intended recipient (or the individual responsible for the delivery of this message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this message is prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.
