過程和函數

1.參數傳遞
create or replace procedure sp_InsertConfig
(
tType varchar2,
vName varchar2,
vDate varchar2
)
as
begin
insert into Config(ConfigID,Type,Name,Data)values(config_sequence.NEXTVAL,vType,vName,vDate);
Exception
when program_error then
rollback;
when others then
rollback;
end sp_InsertConfig;
2。參數模式
create or replace procedure sp_Math_Add
(
v1 number,
v2 number,
sum_value OUT number
)
as
begin
sum_value:=v1+v2;
end sp_Math_Add;

declare
a number;
b number;
c number;
begin
a:=10;
b:=12;
sp_Math_Add(a,b,c);
dbms_output.put_line('c='||c);
end;

3.參數默認值
create or replace procedure sp_add_student
(
sName varchar2,
sDept varchar2:='軟件技術系'
)
as
begin
dbms_output.put_line(sName||'所在的系為'||sDept);
end sp_add_student;

declare
studentName varchar(20);
begin
studentName:='張三';
sp_add_student(studentName);
end;