[Sqlrelay-discussion] Debian 3.1 - SP w/ set nocount off Doesn't Return Results

[Ben G. <me...@be...>]

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