Jim,
I found this in one of the online Oracle docs from 8i Enterprise:
'A PL/SQL procedure executing on an Oracle server can call an external
procedure or function that is written in the C programming language and
stored in a shared library.'
By shared library I presume they mean an .so, a .dll, or the appropriate
operating-system-specific equivalent. This is from Chapter 8 of the
document 'Oracle 8i Concepts'. I haven't seen anything that documents how
you actually make the call, pass params, or identify the shared library to
the Oracle server.
HTH.
At 03:45 PM 3/17/2000 -0500, Dan Newcombe wrote:
>I don't know if it is the easiest way, but I usually have process that is
>running that listens on a DBMS_PIPE and gets what it should run from an
>oracle prodcedure that passes it something like 'ls -l'.
>
>I would think that just having the database run any command passed via
>something like a system() call would be very dangerous.
>
>On Fri, 17 Mar 2000, Jim Lynch wrote:
>
>> I know this isn't Linux subject matter, but I don't know where else I'd
>> find a group of more knowledgeable people than here.
>>
>> I'm trying to figure out how to call an external shell script from
>> within an Oracle stored procedure. I can't find it anywhere in the
>> manuals I have. Can it be done?
>>
>> Thanks for any guidance.
>>
>> Jim.
>> --
>> To unsubscribe: mail ">majordomo@ale.org with "unsubscribe ale" in message
body.
>>
>
>--
>To unsubscribe: mail ">majordomo@ale.org with "unsubscribe ale" in message
body.
>
--
To unsubscribe: mail ">majordomo@ale.org with "unsubscribe ale" in message body.