Can we define a cursor variable to Null
569980Apr 20 2007 — edited Apr 20 2007Hi friends
I have a cursor declared in a package named trx_c
Trx_r is a cursor variable variable of that type.
Now there are certain columns like order_id and transaction id in this cursor.
I'm setting these columns to null individually..Like Trx_r.order_id:=null
Can I set the whole cursor variable i.e. trx_r :=Null.....I don't care abt the other columns to be null
I just want to know whether this will work and if it will have any unexpected consequences on the package...
With Regards
Mohit