So far I have tried to use NO_DATA_FOUND, but it is not working.
Could you help me please?
create or replace procedure sp_select
(p_id_g in t_dml.id_g%type,
c_select out sys_refcursor
)
is
begin
open c_select for select id_g, id_d
from t_dml
where id_g = p_id_g;
exception
when no_data_found then
dbms_output.put_line (‘No data found.’);
end sp_select;