Your can use declared variables in your cursor declarations .
Just make sure the varibles have valid vales before you open the cursor.
>I have a question about cursors. I want to define a cursor based upon
>parameters passed into my PL/SQL program.
>
>I want to look at the parameters the user passes in. If they are valid
>dates, I want to use those dates in my WHERE caluse. Otherwise, I want
>to use SYSDATE.
>
>How can I code a 'conditional' define for a CURSOR since it is done in
>the declaration section??
Received on Tue Nov 16 1999 - 10:16:09 CST
