RE: How to execute a stored proc

[Kotha, Nagaraju]

Here is simple call:

my $sp_sth = 
$dbh->prepare(q{begin
                    my_Pack.my_SP(:in,:out);
                  end;
                   });

$sp_sth->bind_param(":in",$p);
$sp_sth->bind_param_inout(":out",\$v_n,3000);
$sp_sth->execute();


--Raju


-----Original Message-----
From: Tim Harsch [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 15, 2001 11:03 AM
To: [EMAIL PROTECTED]
Subject: How to execute a stored proc


I hate to ask this question since it has been answered about a thousand
times, but since there are probs with the archives here goes....

How do you execute an oracle stored procedure via DBI?

      Tim Harsch
      Lawrence Livermore National Laboratory
      IMAGE Consortium
      7000 East Ave., L-448
      Livermore, CA 94550

      [EMAIL PROTECTED]
      (925) 423-1135