[Sqlrelay-discussion] Debian 3.1 - SP w/ set nocount off Doesn't Return Results
Brought to you by:
mused
|
From: Ben G. <me...@be...> - 2005-09-12 19:37:58
|
Another strange sqlrsh issue on this new Debian 3.1 box: sqlrsh and
sqlrelay's Ruby module won't return stored procedure results if set
nocount is off.
The stored procedure:
CREATE PROCEDURE spTest AS
set nocount off
select 'here'
Results
0> exec {db}.{user}.spTest;
Rows Returned : 0
Fields Returned : 0
System time : 20000
If I change "set nocount off" to "set nocount on", things work
fine--"here" is returned. Interestingly, if I execute the same sp on a
Debian 3.0, both the "nocount on" and "nocount off" versions work
properly (return "here").
Any ideas?
Have a great day!
Ben
|