Re: Cursor Question

From: <rtproffitt_at_my-deja.com>
Date: Tue, 16 Nov 1999 16:45:03 GMT
Message-ID: <80s1me$6pv$1@nnrp1.deja.com>

Arthur,

You can pass parameters into your cursor, Thus, your PL/SQL will look something like this:

Cursor x(vDateparm date) is
select etc.....
where DateField = vDateParm;

Begin
If...... validate the user entered parameters
.... if dates are valid...

workdate := user's parm
else

workdate := SYSDATE;

Open x(workdate);
...etc...

Close x;

Robert Proffitt
Beckman Coulter

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 16 1999 - 10:45:03 CST