Perl Module to execute stored procedure call in MS-SQL Server

[ye_aung]

Hello,

I am trying to write Perl wrapper to run stored procedure in MS SQL
Server. I am looking at the following two Perl modules:

(1) Win32::ODBC
(2) MSSQL::SQLLIB

Here are my requirements:

(1) I need to capture result data set from stored procedures
(2) I need to capture return codes from stored procedures

Unless I am doing wrong, I am unable to capture both result set and
return code from MS SQL Server using those two Perl modules. Can you
point out to me as to what other Perl modules are available to fulfill
my requirements or what I am doing incorrectly.

Here are a few things I learned about those two Perl modules:

(1) Win32::ODBC
It is good at capturing result data set from running SQL statements
such as SELECT, INSERT, UPDATE, and DELETE but not result data set
from stored procedures calls. It does not work for me.

(2) MSSQL::SQLLIB
It has 'sql_sp' function which requires special way of passing
parameters and my stored procedure calls are dynamic with unknown
number of parameters until run-time. It does not work for me.

Thank you,

Ye H. Aung
Database Administrator
Nicholas Applegate Capital Management
San Diego, California
Tel: (619) 652-5417
ye_aung@nacm.com