Hello Experts,I want to know that What is ref cursor? When and where it is used in real time? Can any one explain me the complete scenerio so that I can work accordingly.
Thanks in Advance!
Ref curosr is dynamic cursorRef cursor associated with different select statementsIts work in different work area in memoryRef cursor is valid in procedure and package declarationRef cursor we can declare in package or procedures like thisCreate or replace procedure pnameIsSys _ref cursorEnd
Ref curosr are two types and they are:Weak ref cursorStrong ref cursor
Can you give me an example please?
Explicit cursor is static curosr, reference cursor is dynamic cursor. By using explicit curosr we are going to execute only one select statement by using reference cursor execute multiple select statements. Explicit cursor works on only one memory area but incase of ref cursor works on different work areas.
Sign up for STechies
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.