ORACLE³ÌÐò°ü

³ÌÐò°ü
 
°üÖ÷Ìå/¹æ·¶Ãû×ÖÒ»Ñù
°üÖ÷Ìå/¹æ·¶ÖеĶÔÓ¦²ÎÊý±ØÐëÀàÐͼ°Ãû×ÖÒ»Ñù
Ö»ÄÜʹÓÃÇ¿ÀàÐ͵ÄREFÓαê
 
´´½¨³ÌÐò°ü¹æ·¶
create or replace package my_pack
is
       procedure find_emp_proc(eno emp.empno%type);
       function find_emp_fun(eno emp.empno%type) return emp.ename%type;
end my_pack;
 
SQL> ed
SQL> /
 
Package created
 
µ÷Óú¯Êý
SQL> select my_pack.find_emp_fun(7788) from dual;
 
select my_pack.find_emp_fun(7788) from dual
 
ORA-04068: ÒѶªÆú³ÌÐò°ü  µÄµ±Ç°×´Ì¬
ORA-04067: δִÐУ¬package body "SCOTT.MY_PACK" ²»´æÔÚ
ORA-06508: PL/SQL: ÎÞ·¨ÔÚµ÷ÓÃ֮ǰÕÒµ½³ÌÐòµ¥Ôª
ORA-06512: ÔÚline 1
 
Ö´Ðд洢¹ý³Ì
SQL> exec my_pack.find_emp_proc(7788);
 
begin my_pack.find_emp_proc(7788); end;
 
ORA-04068: ÒѶªÆú³ÌÐò°ü  µÄµ±Ç°×´Ì¬
ORA-04067: δִÐУ¬package body "SCOTT.MY_PACK" ²»´æÔÚ
ORA-06508: PL/SQL: ÎÞ·¨ÔÚµ÷ÓÃ֮ǰÕÒµ½³ÌÐòµ¥Ôª
ORA-06512: ÔÚline 2
 
´´½¨³ÌÐò°üÖ÷Ìå
create or replace package body my_pack
is
       empname emp.ename%type;
       procedure find_emp_proc(eno emp.empno%type)
       is
       begin
                 select ename into empname from emp where empno=eno;
                 dbms_output.put_line(empname);
       end;
       function find_emp_fun(eno emp.empno%type) return emp.ename%type
       is
       begin
                select ename into empname from emp where empno=eno;
      &nb