在Oracle中执行存储过程

SQL> var num_var number
SQL> var txt_var varchar2(15)
SQL> var txt_var2 varchar2(20)

SQL> exec PKGName.ProcedureName(1,\'10/10/2010\',\'10/23/2010\',7,7, :num_var, :txt_var, :txt_var2);

PL/SQL procedure successfully completed
num_var
---------------
42
txt_var
-----------------
some text
txt_var2
-------------------
some other text

SQL> 

declare 
  -- declare variables to keep output values
  output_par_1 varchar2(100);
  output_par_2 number(10);
  ...
begin
  PKGName.ProcedureName(1,\'10/10/2010\',\'10/23/2010\',output_par_1,output_par_2);

  -- display output values
  dbms_output.put_line(\'output_par_1: \' || output_par_1);
  dbms_output.put_line(\'output_par_2: \' || output_par_2);
end;
/

exec PKGName.ProcedureName(1,\'10/10/2010\',\'10/23/2010\',7,7);

SELECT PKGName.ProcedureName(1,\'10/10/2010\',\'10/23/2010\',7,7) FROM DUAL