个回答

• 陈晨辰_

  2019-04-25 16:51:45

  begin

  mypackage01.queryEmpList(20);

  end;

  /

  0

• mkw1351

  2016-07-29 14:29:04

  create or replace package emp_pack is

    type empcursor is ref cursor;

    procedure emp_pro(emp_id in integer,emp_list out empcursor);

  end;

  
  

  create or replace package body emp_pack is

    procedure emp_pro(emp_id in integer,emp_list out empcursor) is

      begin

      open emp_list for select * from employees e where e.employee_id = emp_id;

      end;

  end;

  这样调用吗？

   exec emp_pack.emp_pro(1);

  0

• sntatas

  2016-07-24 12:22:45

  使用select func_name() from dual;

  像正常函数一样调用就好了

  0