encapsulation of SELECT in views or stored procedures

From: <pjbondi_at_SystemDatabase.com>
Date: Wed, 22 Sep 1999 15:32:27 GMT
Message-ID: <7sasqb$di5$1@nnrp1.deja.com>

Hello to all:

We need to retreive recordsets from Oracle. What is the most common method of encapsulation? It is stored procedures or views?

It seems to require quite a lot of code to access Oracle stored procedure to return result sets via ActiveX Data Objects.

ODBC supports REF CURSOR, which seems much easier.

Please comment.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 22 1999 - 10:32:27 CDT