now i am using the follwing stored procedure ,
create or replace procedure my_proc (dept_no in number,p_cur out sys_refcursor)
is
begin
open p_cur for select * from emp where deptno=dept_no;
end my_proc;
/
Procedure created
var a refcursor
exec my_proc(10,:a);------------data available
exec my_proc(100,:a);----------data not available
which way is the best way to maintaine exception handling for the stoderd procedure.
in my java code i call this for dept_no=100 i get error,
how to use exception handling ,and which is the best way
please tell me
subbarao