How Does oracle execute stored procedures?

How Does oracle execute stored procedures?

The stored procedure is as follows:

Create procedure gokul_proc (pId in number, pName in varchar2, OutCur OUT G_PKG_REFCUR.rcDataCursor) isBEGIN Open OutCur For select * from gokul_table ob where ob. active_staus-'y' AND ob. id = pId AND ob. name = pNname; END;

Execute the following in sqlplus:

VAR rc REFCURSOREXEC gokul_proc (1, 'gokul ',: rc); print rc

Reference

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.