Hamish Whittal wrote:
> 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();
>
is this what you have in your code: "$$dbh->prepare($sql)"?
david