Re: Unable to see scama for store procedure of oracle

PURU,

Try this…

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> FOR XML AUTO, XMLDATA
END ;

Nar-