I have called Oracle stored procedures from Perl successfully using bound 
named parameters. I am too busy to reduce my program down to a size 
suitable for posting to a mailing list, but any interested parties may 
e-mail me directly. In a separate message I will respond directly to the 
questioner.

My success has been with Perl  5.005_03 (an older ActiveState build 523) 
and DBI 1.14. I am trying to port it to Cygwin, but am having trouble with 
DBD::ODBC. (The DBD::Oracle part does work, though.) DBI 1.15 causes 
problems with DBD::Oracle for some reason.

    - Paul

At 04:00 PM 4/8/2001 -0700, you wrote:
>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!?!?!

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Paul Anton Chernoch
Zeborg, Inc.
500 West Cummings Park
Woburn, MA 01801

t: 781.759.0105
f: 781.935.5090
c: 781.606.7382

http://www.zeborg.com
This message is a personal and confidential communication. If you are not
the intended recipient, please do not read, copy, or use it, and do not
disclose it to others. Please notify the sender of the delivery error by
replying to this message, and then delete it from your system. Thank you.

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .


Reply via email to