Toad World® Forums

exception when no_data_found then


#1

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;


#2

Hello,

it is Toad Data Modeler forum about modeling etc. I think you need ask in some Oracle forum or Toad for Oracle forum.

Toad for Oracle forum, you can find here https://community.toadworld.com/products/toad-for-oracle/f/10

Daril