oracle的sp语法,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,哈哈,低级错误,没有写代码的经验,晕晕晕!