develooper 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


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About