|
View previous topic :: View next topic
|
| Author |
Message |
learnmf
Active User
Joined: 14 Mar 2005
Posts: 123
|
|
|
|
Dear friends
| Quote: |
I want to declare a cursor for more then one time for different conditions like.
Ex In 1st cursor cola= 'ram'
in Secor cursor declaration cola='bab'
So Can it be possible to declare cursor using temp var so that i can open it more then once by passing desired values in 'cola'. |
|
|
| Back to top |
|
 |
bonniem
New User
Joined: 09 Aug 2005
Posts: 67
|
|
|
|
| Yes it is possible. Just use a host variable in the where clause and move the required value to this variable before opening the cursor. Just make sure that the cycle cursor open, fetch and close is not disrupted. |
|
| Back to top |
|
|
learnmf
Active User
Joined: 14 Mar 2005
Posts: 123
|
|
|
|
| Thanks bonniem |
|
| Back to top |
|
|
|
|
