RE: DBD::ODBC SQL Server Stored Procedure

2012-08-29 Thread Gorrebeeck, Robert
th and Productivity Office: (972) 473-2942 gorrebeec...@cvty.com<mailto:gorrebeec...@cvty.com> www.coventrywcs.com<http://www.coventrywcs.com> From: Gorrebeeck, Robert Sent: Wednesday, August 29, 2012 2:02 PM To: beginners@perl.org Subject: DBD::ODBC SQL Server Stored Procedure All I am ha

Re: DBD::ODBC SQL Server Stored Procedure

2012-08-29 Thread Leo Susanto
Full code please. On Wed, Aug 29, 2012 at 12:01 PM, Gorrebeeck, Robert 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), > @Ref

DBD::ODBC SQL Server Stored Procedure

2012-08-29 Thread Gorrebeeck, Robert
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, @ErrorIDINT OUTPUT And here is my perl code #bind the i