----- Forwarded message from [EMAIL PROTECTED] -----

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!?!?!

Regards from a Newbie.

Thanks in Advance,
Bob Wilson.
 


----- End forwarded message -----

Reply via email to