Full code please. On Wed, Aug 29, 2012 at 12:01 PM, Gorrebeeck, Robert <gorrebeec...@cvty.com> wrote: > 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.
-- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
