I am using External procedures to execute shell scripts, an they are fast.
The C programm only executes the system procedures so we only pass on
variable to it and it would take care of it.
my advise is to make it as general as possible.
Tom
Geoff Muldoon <gmuldoon.nospam_at_scu.edu.au> wrote in message
news:38c5bfbb.79009840_at_nntp.scu.edu.au...
> Hi,
>
> Could anyone please advise if the following is viable or whether
> better options exist:
>
> Environment:
> 8.0.5 on Digital Alpha 4.0e with cc C compiler and Perl 5.005_03.
>
> Requirement:
> From within a number of PL/SQL blocks, be able to call one of a number
> of Perl scripts, each of which accept a number of string variables.
>
> Restrictions:
> PL/SQL User's guide indicates that the only language which is
> supported in calls to external procedures is C. The scripts which we
> wish to use are in Perl.
>
> Proposal:
> Create a DLL containing a series of routines written in C. A single
> routine is written for each of the number of variables which will be
> passed to a Perl script.
>
> E.G. Ext_0 receives one string variable, being the name of a Perl
> script to be executed. Ext_1 receives two string variables, the first
> being the name of a Perl script to be executed and the second being a
> varible passed to that Perl Script. Ext_2 receives three string
> variables, the first being the name of a Perl script to be executed
> and the other two being varibles passed to that Perl Script.
>
> OR
>
> Create a DLL containing a single routine written in C which receives
> two variables, the first of which is the name of the Perl script to be
> executed and the second containing an array which is decoded to
> populate the variables required by the Perl script.
>
> Any advice greatly appreciated.
>
> Geoff M
>
Received on Wed Mar 08 2000 - 00:08:56 CST
