Can't return multiple rows in PL/SQL<->OCI call???

[Quoted] I'm in the process of learning the OCI functions so i can port some Sybase data access functions. In my app all data access is retrieved using stored procedures. The programmer calls a function that binds the input and output variables and then calls the stored procedure.

My question is: If i want to return a result set with multiple rows back to an OCI application, then do i have to use a PL/SQL cursor? Isn't there a way to map the result set to my variables and then perform a fetch to get each row? If i do a

[Quoted] SELECT bob INTO :bobvar

What happens if there are many bob rows? It sounds like calling PL/SQL from an OCI app isn't worth the trouble. Any benefit i might get from using stored procs seems wasted in these details.

Are my above assumptions correct, or am i reading the OCI mannual wrong? It just seems so backwards compared to Sybase's API (client-lib). What am i missing?

thanks!

-david m rosner

-------------------==== Posted via Deja News ====-----------------------

      http://www.dejanews.com/ Search, Read, Post to Usenet Received on Tue Jan 27 1998 - 00:00:00 CET