running external programs

km wrote:

Hi all,

Is it possible in a PLSQL function to call an external program/script residing at /usr/bin and return the result ?

are there any workarounds for this sort of a problem ?

regards,
KM

You can do it with a PLperl function.
You would have to use the untrusted PLperlu though.

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration

On Tuesday 07 November 2006 10:55, km wrote:

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.

Is that a deciding criteria for a language to be flagged trusted or not ?

besides other reasons, yes.

UC

--
Open Source Solutions 4U, LLC 1618 Kelly St
Phone: +1 707 568 3056 Santa Rosa, CA 95401
Cell: +1 650 302 2405 United States
Fax: +1 707 568 6416