call a stored procedure using perl

Perl Tutorial : Perl data types
Perl Tutorial : Perl Operators
Perl Tutorial : Perl loops
Perl Tutorial : Perl Conditionals
Perl Tutorial : Perl Subroutines

Perl Tutorial : Perl regex
Perl Tutorial : Perl Files
Perl Tutorial : Perl & Databases
Perl Tutorial : Perl OOPs
Perl Tutorial : Perl signals
Perl Tutorial : Perl threads
Perl Tutorial : Perl Debugging

Introcution to Perl CGI

Introduction to modperl

Home >>

Invoke stored procedures with DBI

There is currently no standard way to call stored procedures with DBI. However, if you have created a stored procedure within an Oracle database, you can use $dbh->do() to immediately execute the procedure:

$dbh->do("BEGIN myPackage.myProcedure; END;");

in mysql you can use CALL

$dbh->do("CALL Stored_procedure");

Perl functions

scalars and strings

lc
ord

regex (regular expressions)

arrays

shift
split

More..

eval

Share |

Home
perl hello world!
Perl Typeglob

Perl examples

How to use Data::Dumper?

How to parse config file?

Include external module in perl..

Download perl

download stable version of perl
Perl 5.10.1

Perl interview Questions
sed tutorial
awk tutorial

Join us on Google Groups

Subscribe to perl

Email:

Visit this group

Perl Jobs