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;