PL/SQL tutorial 71: PL/SQL SYS_RefCursor in Oracle Database by Manish Sharma

------------------------------------------------------------------------
►►►LINKS◄◄◄

What are actual and formal parameters in programming

Find the Script here

Previous Tutorial
►Weak Ref Cursor

►Strong Ref Cursor

-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
-------------------------------------------------------------------------
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on

___Facebook Official Page of Manish Sharma___

You can also Email me at
for E-mail address please check the About section

Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

[shaylinpadayachee]

I really appreciate how you explain things out fully by going over each item, thanks

[jeeves]

Thank you for sharing your knowledge so freely. Very much appreciated.

[sahukarinaveenkumar]

Very helpful. Thanks for all ur hardwork

[alokmishra]

Thanks for the Excellent tutorial. Can we plz have a tutorial on CURSOR WITH HOLD attribute too? Thanks in Advance.

[deepakranjanmishra]

Manish thanks a lot for such valuable tutorials .If it is possible to give an example of ref_cursor with multiple select statements .Plz advise.

[namratamulwani]

can you please make a video giving knowledge how to take Oracle certification exam and what are the procedures to apply for it.

[divyab]

what do u mean by return type is not know in weak ref cursor, when we are declaring the variables with known datatype and using them to display back.

[arkathesun]

Why should I use sys_refcursor if i can declare the cursor itself in the declare section?

[anujrana]

can you please make a tutorial on detailed description of cursor ex- how it fetches rows when we loop a cursor using cursor
EXAMPLE :-
for cur cursor_variable2 loop
open cursor_variable1 for select * from tab_name where condition;
end loop;

[azarudeens]

While executing weak refcursor im getting subscript beyond count error cause :An in limit subscript was greater than the count of a varry or too large for a nested table
Action:check the program logic and explicitly extend if necessary
My question is it that possible use extend in refcursor plz give me a solution

[Ganeshw]

Hi,
Please make video on UTL package

[SureshKumar-uctz]

Manish Bhai, If possible Can you please add videos related Dynamic SQL Concept

[vishalsaxena]

DECLARE
CUR_VAR SYS_REF CURSOR;
VENAME EMP.ENAME%TYPE;
VSAL EMP.SAL%TYPE;
BEGIN
OPEN CUR_VAR FOR SELECT ENAME, SAL FROM EMP WHERE EMPNO=7369;
FETCH CUR_VAR INTO VENAME, VSAL;
CLOSE CUR_VAR;

END;


I use same cursor but i m facing this error please tell me where i m wrong

[Error] ORA-06550: line 2, column 17:
PLS-00103: Encountered the symbol "CURSOR" when expecting one of the following:

:= . ( @ % ; not null range default character
The symbol ":=" was substituted for "CURSOR" to continue.
ORA-06550: line 9, column 30:
PLS-00103: Encountered the symbol "’" when expecting one of the following:

( - + case mod new null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current max min prior sql stddev sum
(1: 0): >> DECLARE
CUR_VAR SYS_REF CURSOR;
VENAME EMP.ENAME%TYPE;
VSAL EMP.SAL%TYPE;
BEGIN
OPEN CUR_VAR FOR SELECT ENAME, SAL FROM EMP WHERE EMPNO=7369;
FETCH CUR_VAR INTO VENAME, VSAL;
CLOSE CUR_VAR;

END;
Error at line 1
ORA-06550: line 2, column 17:
PLS-00103: Encountered the symbol "CURSOR" when expecting one of the following:

:= . ( @ % ; not null range default character
The symbol ":=" was substituted for "CURSOR" to continue.
ORA-06550: line 9, column 30:
PLS-00103: Encountered the symbol "’" when expecting one of the following:

( - + case mod new null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current max min prior sql stddev sum