Help Please - External Procedures

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 Tue Mar 07 2000 - 20:50:22 CST