本文介绍如何在Oracle数据库的PLSQL环境中调用存储过程，包括变量声明与使用，循环控制等关键步骤。
How to call procedure in PLSQL of Oracle DB.
Note: procedure name, the "()" is not requried
----------------------
[i]Declare
Lcntr number;
LCalc number;
LCalcTmp Number;
Begin
FOR Lcntr IN 1..36
LOOP
myprocedure; -- procedure name, the "()" is not requried
for LCalc in 1..100000000 -- sleep sometime
LOOP
LCalcTmp := LCalcTmp+1;
END LOOP;
END LOOP;
end;[/i]
Note: procedure name, the "()" is not requried
----------------------
[i]Declare
Lcntr number;
LCalc number;
LCalcTmp Number;
Begin
FOR Lcntr IN 1..36
LOOP
myprocedure; -- procedure name, the "()" is not requried
for LCalc in 1..100000000 -- sleep sometime
LOOP
LCalcTmp := LCalcTmp+1;
END LOOP;
END LOOP;
end;[/i]
扫一扫
1264
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
