Hi,
I'm trying to call a stored procedure that needs a "record type paramater".
I'm unclear as to how to pass the record data.  The record data is a hash; I
believe i need to pass in just the values of the hash, as a flattened list
$reg_string.

Something like this?

        my $proc = 'proc_name';
        my $reg_string = 'John,Smith,,123 Main Street,,';

        my $sth = $dbh->prepare("BEGIN $proc(?,?); END;");
        $sth->bind_param(1, $reg_string, { ora_type => ORA_RSET } );
        $sth->bind_param_inout(2, \$self->{_result}, 100);

Right now this throws the following error:
Argument "ORA_RSET" isn't numeric in subroutine entry at lib/Mail/Message.pm
line 515.
Can't bind :p1, ora_type 0 not supported by DBD::Oracle at
lib/Mail/Message.pm line 515.


-1 to 1 Marketing
   eric dietrich riggers
   Developer
   [EMAIL PROTECTED]
   http://www.networkcommerce.com/

Reply via email to