Oracle 11g-运行PL / SQL游标

麻麻

我试图在Oracle 11g上运行此代码，这给了我下面的错误。我似乎无法正确处理。
DECLARE
    CURSOR bookcursor IS
    SELECT btName, BookCopy.Isbn, pubName, dateDestroyed
      FROM booktitle bt
* u1 _) Q6 F9 m0 d: V& @4 @" e      JOIN publisher p
; }! I7 t, T# ^* q; k( i        ON bt.pubId = p.pubId
4 Y/ N6 ?, S" a      JOIN bookcopy bc
        ON bt.Isbn = bc.Isbn
7 V. ^3 G; B, x7 a2 [! `8 G     WHERE datedestroyed IS NULL
2 \. f1 E& G" b3 o$ k# b0 \    ;
    bookcursorrec bookcursor%ROWTYPE;
BEGIN
    OPEN bookcursor;
    LOOP
+ I! D4 c  l, k3 ], L        FETCH bookcursor INTO bookcursorrer;
- q+ ~3 P$ K  S5 U        EXIT WHEN bookcursor%NOTFOUND;
        dbms_output.put_line( 'ISBN: ' ||bookcursorrec.isbn
/ R) e& A  w& a) u                              || ' - Book Name: ' || bookcursorrec.btname
% A3 P" f( Z# X6 R+ G                              || ' - Publisher: ' || bookcursorrec.pubname );
    END LOOP;
    CLOSE bookcursor;
END;
+ v4 Z: V% P/ z7 H7 u% [4 Q
ERROR at line 3:
6 S: M7 O* l0 }" p- rORA-06550: line 3, column 20:
PL/SQL: ORA-00904: "BOOKCOPY"."ISBN": invalid identifier
ORA-06550: line 3, column 5:
PL/SQL: SQL Statement ignored
1 [) N0 K$ s; o0 I+ \ORA-06550: line 2, column 12:
4 k0 y3 p$ ]$ x  w; v5 ]. ^PLS-00341: declaration of cursor 'BOOKCURSOR' is incomplete or malformed
ORA-06550: line 11, column 19:
PL/SQL: Item ignored
9 J1 o, W( T8 xORA-06550: line 15, column 31:
8 F6 K! \* p- C# G; nPLS-00201: identifier 'BOOKCURSORRER' must be declared
$ x6 e* P/ s7 e4 M% f! nORA-06550: line 15, column 9:
' z6 \* v7 c; @PL/SQL: SQL Statement ignored
4 ~' S! p( Q' P' j  N- c" }$ PORA-06550: line 17, column 42:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
6 g. V$ P8 g- z: }! C6 OORA-06550: line 17, column 9:
PL/SQL: Statement ignored
您能指出我出什么问题吗？我似乎无法理解什么地方出了问题
5 f. i% O$ l% e2 E2 b8 S* c谢谢，布莱恩
8 J" Z: Z& `  q6 k               
7 L/ W# I2 f5 f1 c6 d解决方案: