What is diff between strong and weak ref cursors

Questions by ddkdhar   answers by ddkdhar

Showing Answers 1 - 10 of 10 Answers

klnreddy

  • Feb 19th, 2007
 

           A strong REF CURSOR type definition specifies a return type, but a weak definition does not.


DECLARE
   TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE;  -- strong
   TYPE GenericCurTyp IS REF CURSOR;  -- weak

  Was this answer useful?  Yes

Parag Sathe

  • Feb 26th, 2007
 

Strong Ref cursor type is less Error prone, because oracle already knows what type you are going to return as compare to weak ref type.

  Was this answer useful?  Yes

askvenki

  • Jul 20th, 2007
 

           A strong REF CURSOR type definition specifies a return type, but a weak definition does not.
DECLARE
   TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE;  -- strong
   TYPE GenericCurTyp IS REF CURSOR;  -- weak
 in a strong cursor structure is predetermined --so we cannot query having different structure other than emp%rowtype
in weak cursor structure is not predetermined -- so we can query with any structure

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions