I answered you directly last week.  Perhaps you should use SQL*Loader
instead.
--
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: "Tim Bunce" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, April 08, 2001 11:47 AM
Subject: (Fwd) Calling an Oracle Stored Procedure from PERL


> From: [EMAIL PROTECTED] ()
> To: [EMAIL PROTECTED]
> Subject: Calling an Oracle Stored Procedure from PERL
> Date: Fri, 6 Apr 2001 16:13:49 -0700
>
> I am a beginner PERL programmer and looking for some advice if anyone can
> help.  I just started to learn PERL about 2-3 weeks ago and I like it
> alot!!!
>
> 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.
>
> I have installed the DBI, DBD::Oracle modules.  I am able to connect and
> retrieve data from my Oracle db.  Do I need anything more?  It just the
> procedure that I have all my update code written into and compiled reside
on
> the server and I'm not sure how to call the Package.  Help??
>
> Anyone have any suggestions/advice...or better yet....An example piece of
> code with comments would be great if you have one!?!?!


Reply via email to