There are two types of REF CURSORs Strong and Weak. In Strong there is a return type where as in weak there is not. DECLARE TYPE ShopCurTyp IS REF CURSOR RETURN shop%ROWTYPE; -- strong TYPE RefCurTyp IS REF CURSOR; -- weak
Ref Cursors are cursor variables. There are 2 types, Strong (with return type) and Weak (without return type).
Excellent...!
There are two types of REF CURSORs Strong and Weak. In Strong there is a return type where as in weak there is not.
ReplyDeleteDECLARE
TYPE ShopCurTyp IS REF CURSOR RETURN shop%ROWTYPE; -- strong
TYPE RefCurTyp IS REF CURSOR; -- weak
Ref Cursors are cursor variables. There are 2 types, Strong (with return type) and Weak (without return type).
ReplyDeleteExcellent...!
ReplyDelete