Hi
There are many cursor attributes which you can use.
For your req.
use %is_open
Eg: if cursorname%is_o pen then...
code..
Bind variables are a method to improve performance of queries.
They are used usually with execute immediate stmts. in plsql.
A little bit of googling will you its syntax....
ManjunathRG
Last Activity: Aug 31 '07, 04:48 AM
Joined: May 7 '07
Location:
-
TNS means Transparent Network Substrate (TNS)...Leave a comment:
-
It means oracle system identifier...Leave a comment:
-
hi devan,
simple logic says that a= c= 1 . But the condition in your for loop has a a<12 condition. So how can the final value for a be 32..?? If the condition a<12 is ignored then a = c =1 gives a = 32 when b =4. :)...Leave a comment:
-
Hi Reshma
you can find the alert file in oracle\admin\yo urdatabasename\ bdump
reason:i am not sure.. some problem with memory allocation i guess. :)Leave a comment:
No activity results to display
Leave a comment: