Re: cannot execute stored proc from oraperl

Tu Le wrote: (many lines omitted)

>> #

>> $csr1=&ora_open($lda,'EXECUTE get_emp(:1)') || die $ora_errstr; # <<<< line 17

You need to issue a commit, and enclose the stored procedure call in a begin--end block, like this:

$csr1 = &ora_open($lda,'begin execute get_emp(...);commit;end') || ...

oraperl sets the "autocommit" option OFF by default, unlike sqlplus. The same applies to updates or inserts done through oraperl.

Also, I don't know if the ':1' argument will work properly in oraperl. Read the man page to find out.

Carl Tichler
catech_at_cloud9.net Received on Tue Jan 23 1996 - 00:00:00 CET