Structure of a procedure?
Posted by admin on Dec 05 2006
CREATE OR REPALCE PROCEDURE procedurename (parameter(x,y,i) mode(IN,OUT,INOUT) type(char,varchar,numer)) AS/IS
variable declaration
BEGIN
procedure body
END procedurename(optional);
CREATE OR REPALCE procedure statement replaces any previous version of that procedure in the same schema with new version without warning
Leave a Comment