Hi all,
I have a stored procedure that is defined as follows:
PROCEDURE Add_ComponentDetails(
p_ComponentID IN number,
p_PollingID IN number,
p_Answer IN varchar2,
p_ASNNumber IN varchar2)
In my perl code, I exec the following:
my $plsql_params = "'" . join("', '", $ASNNameHash->{compID},
$pollID,$answer, $asnNum) . "'" ;
my $sql = qq{BEGIN
DEVICE_MANAGEMENT.ADD_COMPONENTDETAILS($plsql_params); END;};
print qq(\n*****-->$sql<--*****\n) if $debug;
$sth = $$dbh->prepare($sql); # End of the prepare
$sth->execute();
Now, when I execute program, I produce output and have determined that
the SP is being called correctly. Thus, this is from the output of
running the code.
BEGIN DEVICE_MANAGEMENT.ADD_COMPONENTDETAILS('17', '22', 'pm-16a',
'.1.3.6.1.4.1.9.3.6.11.1.2.3'); END;
When I submit this in SQLPlus, it works like a bomb, but when submitting
it from the perl code above, it does absolutely nothing. I am at a
complete loss of why this could be. I am running the following:
Oracle9i Enterprise Edition Release 9.2.0.1.0
Perl DBD::Oracle v 1.12
Perl: v5.6.1 built for sun4-solaris
Hope someone can shed some light on this one as I have tried many
permutations and cannot see what is going on.
Thanks in advance.
Excuse the cross posting, but I thought some folk on the beginners list
might know the answer....
Cheers
H
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
