PL/SQL Cursors and Tables

Hi,

From Delphi, I call a stored procedure that passes out a PL/SQL table. This table is filled with values obtained from a cursor that does a simple select.

This cursor seems especially slow, even though the select is simple. In fact, it is faster to just run the select directly from Delphi using an Oracle data access component. But we don't want to do this because we'd like everyone to use stored procedures as their API instead of running select queries here and there.

My question is: Is there a way to make the cursor quicker? Is there a way to populate a PL/SQL table without a cursor?

Salaam Yitbarek

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 22 1999 - 09:16:48 CDT