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