Re: Unable to see scama for store procedure of oracle

 Hi Nar_BTS.

My store procedure is like this..which i am not able to see in schemas.

CREATE OR REPLACE
PROCEDURE RET_REF_CURSOR
( p_return_cur OUT SYS_REFCURSOR)

IS
BEGIN
  OPEN p_return_cur FOR
  SELECT * FROM emp_mast WHERE <CONDITION HERE>
END ;

Regards.

Puru.