Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle stored procedure
On Jun 4, 11:59 am, colmkav <colmj..._at_yahoo.co.uk> wrote:
> Hi, I am replacing VBA Access code with Oracle stored procedures. Is
> there an equivalent in Oracle/PL SQL to recordsets in Access.
>
> I basically need to replace code that returns a recordset from a table
> and then process each record within the recordset (ie rs =
> db.Openrecordset(select * from q_exposureTypeID))
http://asktom.oracle.com/tkyte/ResultSets/index.html
-- Sybrand Bakker Senior Oracle DBA Fact: 99.9 percent of all questions on any Oracle forum have already been asked and answered over and over again. This is because most posters think they are the first to run into a problem and consequently don't search Google. They are wrong: they are not unique, they are with *too many*Received on Mon Jun 04 2007 - 05:34:51 CDT