Exception In Ref Cursor

[tedlaraghu]

Hi all,
How can i raise an exception in ref cursor.

CREATE OR REPLACE PACKAGE demo
is
TYPE empcurtyp IS REF CURSOR;
PROCEDURE getempdetails(job_title in varchar2, emp_refcur out empcurtyp);
END demo;


CREATE OR REPLACE PACKAGE BODY demo
IS
PROCEDURE getempdetails(job_title in varchar2,emp_refcur out empcurtyp)
IS
BEGIN
OPEN emp_refcur
FOR
SELECT *
FROM emp
WHERE job = job_title;
EXCEPTION
WHEN no_data_found
THEN
dbms_output.put_line('No Data for '|| job_title);
end getempdetails;
end;

Var a refcursor
exec demo.getempdetails('President',:a)

If there is no job_title as 'President',i need to display these message
dbms_output.put_line('No Data for '|| job_title);

Thanks
Raghu

[debasisdas]

You can't use dbms_output.put_line to print a ref cursor.