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;
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;