create or replace procedure first_symbol (d_code out number, f_date out char, t_date out char) as row rowid; begin select min(rowid) into row from symbol; select symbol_code,symbol,symbol_desc into d_code,f_date,t_date from symbol where rowid=row; exception when no_data_found then null; end; /