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/