Sample Oracle Stored Procedure

CREATE OR REPLACE PROCEDURE sp_MEMBERAPP
(
p_Parameter1 IN VARCHAR2,
p_Parameter2 IN VARCHAR2,
p_Parameter3 IN VARCHAR2
)
AS
BEGIN
INSERT INTO MEMBER
(
ID,
NAME,
ADDRESS,

)
VALUES
(
p_Parameter1,
p_Parameter2,
p_Parameter3
) ;

END sp_MEMBERAPP ;