I have a stored procedure that returns a a jpeg file as a blob. When I
invoke this procedure I am receiving the following error:
DBD::Oracle::st execute failed: ORA-06553: PLS-306: wrong number of types of
arguments in call to 'GETFRONTPIC'
Any suggestions as to what is wrong? Perhaps I just have a blind spot, but I
am stopped dead as to how to solve this problem. I did run a trace, but
frankly, the trace output did not mean much to me.
The parameters for the GETFRONTPIC stored procedure are :
( ord_procedure_path IN varchar2,
ord_procedure_path2 IN varchar2,
ord_procedure_path4 IN varchar2,
ord_content_type OUT VARCHAR2,
ord_content_length OUT NUMBER,
ord_content_blob OUT BLOB
)
My perl code is (I removed some comments and error trapping to keep the
message smaller):
my $dbh = DBI->connect("DBI:Oracle:",'userid@orabank','password')
or die "Cannot connect error: " . DBI::errstr;
$dbh->{LongReadLen} = 180000;
$dbh->{LongTruncOk} = 1;
my $csr = $dbh->prepare( q{CALL checkimages.getfrontpic(?,?,?,?,?,?)}) ||
die "Can't prepare statement: $DBI::errstr";
$csr->bind_param(1,$acctnbr);
$csr->bind_param(2,$checknbr);
$csr->bind_param(3,$seqnbr);
$csr->bind_param_inout(4,\$content_type,20);
$csr->bind_param_inout(5,\$content_len,20);
$csr->bind_param_inout(6,\$content_img,180000,{ora_type => ORA_BLOB} );
$csr->execute;