Hi Everyone,
I've a doubt regarding strong and weak ref cursor.
Difference :
- Strong ref_cursor will always use to return a value and compiler know the structure during the compile time, but in the weak ref cursor it will not return a value and compiler doesn't know the structure during the compile time (it's known at the run time when the cursor will be open).
- Dynamic query is not possible in strong reference cursor where as it is possible in weak reference cursor
So my question is, if weak ref cursor is capable of handling multiple queries (Dynamically); then why it's considered as weak?? Is it because of it's return type is unknown at the compilation time or what?? Why would we consider this as weakly typed?? Please suggest something.
Regards,
BS2012.