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.