Re: Stored procs that returns resultsets to perl

2003-11-28 Thread Martin Busik
Hi, > I actually mean results sets, multiple rows returned. > I have had problems with the exact syntax against > ms sql server all the time, and was worried it is not possible to do it. > I was able to find more references to Oracle by googling etc but thay > syntax didn't seem to work for me as

Re: Stored procs that returns resultsets to perl

2003-11-27 Thread Martin Busik
Hi, > 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? Do you mean "result value" (scalar value in terms of perl) or "result set" (more than one row)? If you mean "result value" then you can use

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