Front page | perl.dbi.users |
Postings from February 2001
bind_in_out
Thread Next
From:
c.w.huling
Date:
February 20, 2001 11:03
Subject:
bind_in_out
Message ID:
14994.49013.60427.707235@cx528142-a.vbch1.va.home.com
I apologize for not including an example earlier, I was hoping someone
would identify an known error. I have made a smaller example of the
larger picture:
Code Sample:
my $stmt=$DBH->prepare('BEGIN
test_intonly( ? );
END;');
my $result;
my $rv = $stmt->bind_param_inout(1, \$result, 0, { ora_type => ORA_RSET });
$stmt->execute;
Oracle Procedure:
teedev >desc test_intonly;
PROCEDURE test_intonly
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OUT_INT NUMBER IN/OUT
Error Message:
DBD::Oracle::st execute failed: ORA-06550: line 2, column 33:
PLS-00306: wrong number or types of arguments in call to 'TEST_INTONLY'
ORA-06550: line 2, column 33:
PL/SQL: Statement ignored (DBD ERROR: OCIStmtExecute) at ./s.pl line 20.
--
C Wayne Huling <c.w.huling@pobox.com>
Thread Next
-
bind_in_out
by c.w.huling