CREATE [ OR REPLACE ] PROCEDURE [ schema . ] procedure ( argument [ { IN | OUT | IN OUT } ] datatype [ , argument [ { IN | OUT | IN OUT } ] datatype ] ) RETURN datatype [ AS | IS ] pl/sql_subprogram_bodyCREATE OR REPLACE PROCEDURE my_procedure ( arg_1 IN OUT varchar2 ) IS begin //语句 execiption //异常语句 end ;
create or procedure pro_name(p in varchar2) as begin dbms_output.put_line(p); end; /
( argument [ { IN | OUT | IN OUT } ] datatype [ , argument [ { IN | OUT | IN OUT } ] datatype ] )
RETURN datatype [ AS | IS ] pl/sql_subprogram_bodyCREATE OR REPLACE PROCEDURE my_procedure
( arg_1 IN OUT varchar2 )
IS
begin
//语句
execiption
//异常语句
end ;
as
begin
dbms_output.put_line(p);
end;
/