Hello again...
Well with all the help earlier with learning about database connections, I've hit my last (hopefully) hurdle. All the help here setting up my server,etc.. has been great, now yet another question... I will post the code, then the error from the screen. This is just the basics, I have more functionality to it, but that will be added once this is up and working. here we go....

(Win 2000 platform) This is my code:
I will also note that this was not my original code, I did make an attempt and an online tutorial as well as using my books (oreillys Perl Cookbook and Perl in Nutshell)... so there might be something that I'm missing, should be changed, etc. I was thankful enough for the person who helped me out with this so far... 
#!perl -w

#########################################################
# This perl script will go to the oracle database, run the stored proc
+edure 
#     LINES_EXTRACT and update the ......
#    This will also take each line data and run so that R.R. will exec
+ute.
#
#     October 17, 2001
#########################################################

use strict;
use DBI;

#make the oracle connection
my $dbh = DBI->connect('dbi:Oracle:Db001','developer','developer2',
    {
        RaiseError => 1,
        AutoCommit => 0
    }
) || die "Database connection not made: $DBI::errstr";

my $rv; 
eval {
   my $func = $dbh->prepare(q{
     BEGIN
       :rv := jb_function( parameter1_in => :parameter1);
   END;
  });
  $func->bind_param(":parameter1", 'pizza');
  $func->bind_param_inout(":rv", \$rv, 256);
  $func->execute;
   
    $dbh->commit;
};

if( $@ ) {
    warn "Execution of stored procedure failed: $DBI::errstr\n";
    $dbh->rollback;
}
print "Execution of stored procedure returned $rv\n";

$dbh->disconnect;

[download]

Here is the error message...
C:\Perl>connect_4.pl
Execution of stored procedure failed: ORA-06550: line 3, column 15:
PLS-00201: identifier 'JB_FUNCTION' must be declared
ORA-06550: line 3, column 8:
PL/SQL: Statement ignored (DBD ERROR: OCIStmtExecute)
Use of uninitialized value in concatenation (.) or string at C:\Perl\c
+onnect_4.p
l line 43.
Execution of stored procedure returned

[download]

I have checked/searched this sight for past postings and now I hit a roadblock and I need those extra eyes to find my faults... and what is 'JB_FUNCTION'?
Thank you all in advance for any help... and I hope this posting will help others too and learn from my mistakes.
humble brother Zo.

In reply to Calling a Stored Procedure (Oracle) from Perl by Zo

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.