Re: bind_in_out

I guess the problem is with the type you bind to : ORA_RSET is for binding to
REF CURSORs, not for ints.
Why don't you try {ora_type => ORA_NUMBER} ?

Mark


c.w.huling@pobox.com wrote:

> 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>

--
Mark Vandenbroeck                      Mobile : +32-495-59.55.62
EMEA Support Information Systems       Email  : Mark.Vandenbroeck@oracle.com
                                       AIM    : markvdb

• bind_in_out by c.w.huling
• Re: bind_in_out by Mark Vandenbroeck