Oracle函数中,有些函数带out参数是咋回事
Oracle函数中,有些函数带out参数是怎么回事
Oracle函数中,有些函数带out参数是怎么回事
如:
Function rf_shcreatecxd(pishorder In Varchar2,
pidepartment In Varchar2,
piworkserial In Varchar2,
piprintarea In Number,
pocxdserial Out Varchar2,
poerrmsg Out Varchar2) Return Int;
------解决方案--------------------
和函数一样是返回值
lv_pocxdserial
lv_poerrmsg
rf_shcreatecxd(pishorder=>,
pidepartment =>,
piworkserial =>,
piprintarea =>,
pocxdserial =>lv_pocxdserial,
poerrmsg =>lv_pocxdserial)
调用后 ,变量就会被赋值
------解决方案--------------------
Oracle函数中,有些函数带out参数是怎么回事
如:
Function rf_shcreatecxd(pishorder In Varchar2,
pidepartment In Varchar2,
piworkserial In Varchar2,
piprintarea In Number,
pocxdserial Out Varchar2,
poerrmsg Out Varchar2) Return Int;
------解决方案--------------------
和函数一样是返回值
lv_pocxdserial
lv_poerrmsg
rf_shcreatecxd(pishorder=>,
pidepartment =>,
piworkserial =>,
piprintarea =>,
pocxdserial =>lv_pocxdserial,
poerrmsg =>lv_pocxdserial)
调用后 ,变量就会被赋值
------解决方案--------------------
- SQL code
create or replace procedure compute(num1 in out number,num2 in out number) is v1 number; v2 number; begin v1 := num1/num2; v2 := mod(num1,num2); num1 := v1; num2 := v2; end;
------解决方案--------------------
输出参数
------解决方案--------------------
那不相當於返回兩個值?或多個值?