在sqlplus中呼叫編寫的refcursor 遊標型別的儲存過程

SQL> var x refcursor
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