Hi, today I am talking about variable decleration inside a procedure....
CREATE OF replace PROCEDURE procedure_name
p_parameter type[VARCHAR(20)];
AS
v_variables number(10);
BEGIN
--PROCEDURE BODY
END;
here v_variables is my variable in number datatype. Just look at that he is lies in between AS and BEGIN keywords.
CREATE OF replace PROCEDURE procedure_name
p_parameter type[VARCHAR(20)];
AS
v_variables number(10);
BEGIN
--PROCEDURE BODY
END;
here v_variables is my variable in number datatype. Just look at that he is lies in between AS and BEGIN keywords.
No comments:
Post a Comment