Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle stored procedure

Re: Oracle stored procedure

From: sybrandb <sybrandb_at_gmail.com>
Date: Mon, 04 Jun 2007 03:34:51 -0700
Message-ID: <1180953291.667491.282910@n4g2000hsb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US