Witango-Talk: Sybase Stored Procedures Multiple Result Sets

[Bryan Hughes]

Calling a Sybase ASA stored procedure but it is not completing.

When I call the stored procedure I call the stored procedure I am 
getting a value returned but on the sybase server it's not completing 
the procedure call when I look at debugging info I send to the database 
console.

My Procudure

procedure1()
        print 'This is before procedure2 debug info';
        call procedure2();
        print 'This is after procedure2 debug info';
        
        .....
	print 'More stuff done here';

        Select 'This should be returned as my result set' AS 'resultSet';
end
On the console I get to 'This is before procedure2 debug info' but then 
it stops.

I think the reason it stop is because it thinks the return from the 
call of procedure2 is the resultSet.

How do I handle multiple results sets without going and rewriting all 
the SQL for this prebuilt application.



Bryan Hughes
TFG-PIU
954-493-6565 x122
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf