Re: Stored Procedures : How to get a reasult set back ( Multiple Rows )

Thanks Terry,

That was really helpful,

Warm Regards,

Yahoo.

Terry Dykstra <tdykstra_at_cfol.ab.ca> wrote in message news:383d85d4_1_at_news.cadvision.com... Here is a PB example to retrieve into a datawindow. You might want to use the Powerbuilder newsgroup, found on news server forums.sybase.com

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

Yahoo wrote in message <81io44$4vn$1_at_clematis.singnet.com.sg>...


>Hi ,

>

>Can anyone please help me out on this one ??

>

>I am using PB 7.0 as a frontend and Oracle 8.0.4 as backend. I want to get

a


>set of rows into the PB program from a oracle stored procedure.

>Is this possible ? Can I get a set of rows out of the procedure at a single

>go or do I have to call the stored procedure again and again for each row I

>want to retrieve.

>

>Any help will be appreciated.

>TIA

>

>Yahoo.

>

>