Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I define a cursor programmatically ?
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
![]() |
![]() |