On Sun, 28 Apr 2002 22:44:27 -0400 Ed Ricci <[EMAIL PROTECTED]> wrote:
> The DBI is version 11.2. Ideally a status/single result set. I did rtfm > before I posted the ques.: > ????????????? > =head2 5.3 How can I invoke stored procedures with DBI? > The DBI does not define a database-independent way of calling stored > procedures. > However, most database that support them also provide a way to call > them from SQL statements - and the DBI certainly supports that. > So, assuming that you have created a stored procedure within the target > database, I<eg>, an Oracle database, you can use C<$dbh>->C<do()> to > immediately execute the procedure. For example, > $dbh->do( "BEGIN someProcedure; END;" ); # Oracle-specific > You should also be able to C<prepare> and C<execute>, which is > the recommended way if you'll be calling the procedure often. > ????????????? There is also a fine manual for DBD::DB2. Run 'perldoc DBD::DB2' to read it. It should describe DB2 specific methods for calling procedures. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
