On Sun, Apr 08, 2001 at 07:47:16PM +0100, Bob.Wilson wrote:
> 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.

The DBD::Oracle documentation contains several very good examples
of calling Oracle packaged subprograms, procedures and functions,
both with and without bind variables.  Please have a look at this
documentation.  Assuming you have DBD::Oracle installed properly,
you should be able to use 'man DBD::Oracle' to get to this information.

-- 
  Allen Campbell       |  Lurking at the bottom of the
  [EMAIL PROTECTED]   |   gravity well, getting old.

Reply via email to