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: How can I define a cursor programmatically ?

Re: How can I define a cursor programmatically ?

From: Paul Quenneville <paulq_at_home.com>
Date: Mon, 26 Nov 2001 23:08:37 GMT
Message-ID: <VXzM7.187943$5h5.82953226@news3.rdc2.on.home.com>


pass the date as a parameter to the cursor.

"Stanley Shapiro" <stanley.shapiro_at_wcom.com> wrote in message news:326e0677.0111261312.54851073_at_posting.google.com...
> I need to generate a select with conditions that change at each
> execution. For example, WHERE DATETIME=date1 or DATETIME=date2 or
> DATETIME=date3 ...
> I have coded the set of computed values date1, date2,... as elements
> of a VARRAY named 'dates'.
> I cannot figure out how to put together the procedure that computes
> 'dates' with the procedure that runs the SELECT.
Received on Mon Nov 26 2001 - 17:08:37 CST

Original text of this message

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