I am currently having an issue with sending multiple variables to a Oracle
procedure. When I do this the CGI script I am using reports that the script
has run successfully. But when I check the database it only received the
first variable.
Example:
If my procedure looks like this:
create or replace procedure foo
(v_some_data IN some_table.some_column%TYPE,
v_some_data2 IN some_table.another _column%TYPE)
as
begin
insert into some_table
values(v_some_data, v_some_data2);
end;
/
and I evoke the command by the following:
my $dbh = DBI->connect("dbi:Oracle:$srvc", $user, $passwd,
{ AutoCommit=>0, RaiseError=>1 } )
or die "connect problem: $DBI::errstr";
$sth = $dbh->prepare(qq{
BEGIN
FOO(:some_data, :some_data2);
END;
});
$sth->bind_param(":some_data", $some_data);
$sth->bind_param(":some_data2", $some_data2);
$sth->execute;
$dbh->disconnect();
exit (0);
I am using DBD::Oracle-1.12 and DBI 1.21. Any help would be appreciated.
-Bruce Powell
___________________________________________________________________________
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.
