Hi,
this is Sudarsam..am having a doubt..
am able to calling procedure but not a function..
see this is my program.
............... .....
CREATE OR REPLACE FUNCTION EMPFUN ( V_DATA IN OUT SYS_REFCURSOR )
RETURN NUMBER
IS
BEGIN
OPEN V_DATA FOR
SELECT * FROM EMP;
END;
............... ....
this is my function....... how can i call this function in sql*plus
can any one guide me about this...
thanks..
this is Sudarsam..am having a doubt..
am able to calling procedure but not a function..
see this is my program.
............... .....
CREATE OR REPLACE FUNCTION EMPFUN ( V_DATA IN OUT SYS_REFCURSOR )
RETURN NUMBER
IS
BEGIN
OPEN V_DATA FOR
SELECT * FROM EMP;
END;
............... ....
this is my function....... how can i call this function in sql*plus
can any one guide me about this...
thanks..