All
I am having an issue with retrieving output parameters from a SQL Server stored
procedure.
Here is the definition of the stored procedure
PROCEDURE [TestProcess]
@Id NUMERIC(20,0),
@RefID CHAR(36) OUTPUT,
@ErrorID INT OUTPUT
And here is my perl code
#bind the input and output parameters
$sth->bind_param(1, $clm_tracking_id);
$sth->bind_param_inout(2, \$ID, DBI::SQL_CHAR);
$sth->bind_param_inout(3, \$ErrorId, DBI::SQL_INT);
$sth->execute();
$sth->finish;
print "$ID\n";
print "$ErrorId\n";
When I run the stored procedure by itself , I get values back, but when I run
it from my perl script, the values are empty.
Not sure what is going on - any advice would be greatly appreciated
Thanks
Robert Gorrebeeck
Email Confidentiality Notice: The information contained in this transmission is
confidential, proprietary or privileged and may be subject to protection under
the law, including the Health Insurance Portability and Accountability Act
(HIPAA).
The message is intended for the sole use of the individual or entity to whom
it is addressed. If you are not the intended recipient, you are notified that
any use, distribution or copying of the message is strictly prohibited and may
subject you to criminal or civil penalties. If you received this transmission
in error, please contact the sender immediately by replying to this email and
delete the material from any computer.
