Re: accessing package from perl script.

On May 5, 12:15 am, balameena <meera..._at_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();