john_at_snapjax.com (John Hamm) wrote in <86num4$ela$1_at_news.gate.net>:
>create procedure test
>...
> select * from patients
yes you can do that in sybase and sql-server (yawn) but this is oracle so
it is different. look into refcursors which allow a proc to open a cursor
and then pass it back to the calling program for use. you will not need to
restrict the cursor to 25 rows; the program can fetch from the cursor
until it is out of data.
--
dave mausner
Received on Wed Jan 26 2000 - 20:51:01 CST
