There are a couple examples in the output from 'perldoc DBD::Oracle'. You
can also see a working script that calls a procedure if you download
DBD-Oracle-1.06.tar.gz from CPAN and look in Oracle.ex/.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 05, 2001 9:46 AM
Subject: Calling Stored Procedures from PERL
> I am a beginner PERL programmer and looking for some advice if anyone can
> help.
>
> The problem...I currently receive a daily flat file that is loaded into an
> Oracle (8.0.5) database. When I assumed responsibility of this system the
> PERL scripts were already written. Since some of the data is incorrect
that
> gets loaded into the Oracle db I need to update it. I have written an
> Oracle Package (Stored Procedure) in PL/SQL to perform this update
HOWEVER,
> I don't know how to call the package from the PERL script. I'm assuming
it
> is relatively simple however I'm unsure and was looking for some help.
>
> Anyone have any suggestions/advice??
