oracle中如何调用存储过程

http://topic.csdn.net/t/20060304/17/4592756.html

 

http://topic.csdn.net/t/20040819/15/3290413.html

SQL窗口:
call   procedure_name(parameter);
begin   procedure_name(parameter);   end;

COMMAND窗口:
exec   procedure_name(parameter);
execute   procedure_name(parameter);
call   procedure_name(parameter);
begin   procedure_name(parameter);   end;

 

 

--变量定义
var   输出参数   varchar2(100)
--执行
exec   存储过程名( '输入参数1 ',.. '输入参数n ',: '输出参数1 ',..,: '输出参数n ');
--显示返回值
print

 

======

http://stackoverflow.com/questions/5822241/pl-sql-print-out-ref-cursor-returned-by-a-stored-procedure

VARIABLE x REFCURSOREXEC GetGrantListByPI(..., :x)PRINT x