Oracle存储过程

create or replace procedure <porcedure_name>
[(参数名参数类型以及描述,....)]

is
[变量声明,...];
begin
[过程处理];
exception
when 异常 then
end;

SELECT col1,col2 into v_col1,v_col2 FROM typestruct where condition;