How we run a oracle stored procedure from perl script...
Command is exec packagename.procedure name
For sybase , it is just calling "exec procedure"
any help is appreciated.
thanks
On 4 May 2007 12:15:18 -0700, balameena <meera
@gmail.com> wrote:
>How we run a oracle stored procedure from perl script...
>Command is exec packagename.procedure name
>For sybase , it is just calling "exec procedure"
>any help is appreciated.
>thanks
exec is a sql*plus acronym for BEGIN ... END;
exec is NOT SQL.
Now draw your conclusions.
--
Sybrand Bakker
Senior Oracle DBA
-----------------------------------------------Reply-----------------------------------------------
balameena (meera
@gmail.com) wrote:
: How we run a oracle stored procedure from perl script...
Perl needs the DBI module, which is probably already installed.
Perl needs the DBD::Oracle module, which you probably have to install
unless your perl came with Oracle.
Then run
perldoc DBD::Oracle
to read all about how to use it.
-----------------------------------------------Reply-----------------------------------------------
On May 5, 12:15 am, balameena <meera
@gmail.com> wrote:
> How we run a oracle stored procedure from perl script...
> Command is exec packagename.procedure name
> For sybase , it is just calling "exec procedure"
> any help is appreciated.
> thanks
something like this will help:
$dbh = DBI->connect("DBI:Oracle:dbname", $username,$password);
$sth = $dbh->prepare( "begin procedure_name; end;");
$sth->execute();
$sth->finish();
$dbh->disconnect();
Add to del.icio.us |
Digg this |
Stumble it |
Powered by Megasolutions Inc
