Stored procs that returns resultsets to perl

2003-11-26 Thread Ozgur Demirtas
Gurus, Is there anybody out there that can give an example of calling a stored proc from within perl and then fetch the result set returned by the proc? I have always run into trouble when I have tried doing this from ActiveState to call procs in ms sql server. I find it easier to call procs tha

sql server 2000 and stored proc returning cursor to perl

2003-10-14 Thread Ozgur Demirtas
hi, I am trying to run a stored procedure in Microsoft SQL 2000. The stored procedure is supposed to return a cursor back to perl. In the code below I am unable to find the codes I have marked with "?". I assume, the "?" represent the DBIC cursor data type and I can not seem to find the code for