create or replace procedure update_symbol(s_code in number,s_name in varchar2, s_desc in varchar2) as begin update symbol set symbol = s_name , symbol_desc = s_desc where symbol_code = s_code ; commit; end; /