2008/6/10 John Scoles <[EMAIL PROTECTED]>: > unfortunately the second package does not compile as it 'returns 1' which is > not a valid pl/SQL command >
Sorry. This one should work fine.
After package compilation, try to call it like this:
$sSQL = q{
begin
test_pack.test_func(:i_nparam1
, :i_dtparam2
, :i_dtparam3
, :o_ndays
);
end;
};
$sth = $objDB->{DB}->prepare($sSQL);
$sth->bind_param(':i_nparam1', 1);
$sth->bind_param(':i_dtparam2', $sDateStart);
$sth->bind_param(':i_dtparam3', $sDateEnd);
$sth->bind_param_inout( ':o_ndays', \$iDaysCnt, 100000 );
As before, PLS-00307 occurs.
--
WBR, Eugene Krivdyuk
test_pack.pck
Description: Binary data
