oracle plsql package_body_procedure_構建語法_sp_儲存過程

SQL> create or replace package pkg_E_TEACHERLOGININFO #定義包

 #包中定義各種儲存過程及型別名字及輸入輸出引數,具體處理邏輯在包體中編寫
  2 
  3  as
  4      type entiry is ref cursor;
  5      procedure p_veriry_teacher_login(v_loginname varchar2,v_password varchar2,v_rc out entiry);
  6  end   pkg_E_TEACHERLOGININFO; 
  7  /

Package created.

SQL>
SQL>
SQL>

 

#定義包體,包體中編寫具體的儲存過程邏輯
SQL> create or replace package body pkg_E_TEACHERLOGININFO
  2  is
  3    procedure p_veriry_teacher_login(v_loginname in varchar2,v_password in varchar2,v_rc out entiry)
  4    as
  5     v_sqlstr varchar2(4000);
  6     begin
  7      v_sqlstr:='select loginid,teacherid,loginname,nickname,password,isnormal,loginstatus,createtime,latestlogintime,latestmodifytime,failedtime,failedip,latestloginip,latestloginarea,memo from E_TEACHERLOGININFO where loginname='||v_loginname||' and  password='||v_password;
  8        open v_rc for v_sqlstr;
  9    
 10    end p_veriry_teacher_login;
 11  end pkg_E_TEACHERLOGININFO;
 12  /

Package body created.

SQL>

 

 

 

1/14     PLS-00103: Encountered the symbol "PKG_E_TEACHERLOGININFO" when
         expecting one of the following:
         is authid as compress compiled wrapped
         The symbol "authid" was substituted for "PKG_E_TEACHERLOGININFO"
         to continue

 

 

以上錯誤表明:create or replace package body寫成create or replace package bady,哈哈,低階錯誤,沒有寫程式碼的經驗,暈暈暈!