存储过程创建模版

create or replace procedure bb(
code OUT NUMBER,
msg OUT VARCHAR2,
c IN VARCHAR2
) as
--变量
ff varchar2（256);
cursor cur(dd varchar2) is
select * from table;
gg dd%ROWTYPE;

begin

EXCEPTION
msg:='错误代码'||SQLCODE||CHR(13)||'错误信息'||SWLERRM
END;