SQL> var x refcursor
SQL> exec pkg_e_teacherlogininfo.p_veriry_teacher_login('1','1',:x);
SQL> exec pkg_e_teacherlogininfo.p_veriry_teacher_login('1','1',:x);
PL/SQL procedure successfully completed.
SQL> print :x
LOGINID TEACHERID LOGINNAME
---------------- ---------------- --------------------
NICKNAME
--------------------------------------------------------------------------------
PASSWORD I LOGINSTATUS CREATETIM LATESTLOG LATESTMOD FAILEDTIM
-------------------- - ---------------- --------- --------- --------- ---------
FAILEDIP
--------------------------------------------------------------------------------
LATESTLOGINIP
--------------------------------------------------------------------------------
LATESTLOGINAREA
--------------------------------------------------------------------------------
MEMO
--------------------------------------------------------------------------------
30 1
---------------- ---------------- --------------------
NICKNAME
--------------------------------------------------------------------------------
PASSWORD I LOGINSTATUS CREATETIM LATESTLOG LATESTMOD FAILEDTIM
-------------------- - ---------------- --------- --------- --------- ---------
FAILEDIP
--------------------------------------------------------------------------------
LATESTLOGINIP
--------------------------------------------------------------------------------
LATESTLOGINAREA
--------------------------------------------------------------------------------
MEMO
--------------------------------------------------------------------------------
30 1