Stored Procedure

Question

This is the structure of SP
Create Stored Procedure ABC
as
begin
end

Answer 1

create or replace procedure SP_CUSTOM(id in number, p_result out varchar2) as
BEGIN
(...your procedure...)
EXCEPTION (...)
END;