plsq集合类型定义

我试图根据本文提供的说明进行插入 site

    CREATE OR REPLACE PROCEDURE test_proc (p_array_size IN PLS_INTEGER DEFAULT 100)
IS
TYPE ARRAY IS TABLE OF all_objects%ROWTYPE;
l_data ARRAY;

CURSOR c IS SELECT * FROM all_objects;

BEGIN
    OPEN c;
    LOOP
    FETCH c BULK COLLECT INTO l_data LIMIT p_array_size;

    FORALL i IN 1..l_data.COUNT
    INSERT INTO t1 VALUES l_data(i);

    EXIT WHEN c%NOTFOUND;
    END LOOP;
    CLOSE c;
END test_proc;
/

同样,为了实际使用,我更改了表名,如下所示。

    CREATE OR REPLACE PROCEDURE test_proc (p_array_size IN PLS_INTEGER DEFAULT 100)
IS
TYPE ARRAY IS TABLE OF web.salesline%ROWTYPE;
l_data ARRAY;

CURSOR c IS SELECT * FROM web.salesline;

BEGIN
    OPEN c;
    LOOP
    FETCH c BULK COLLECT INTO l_data LIMIT p_array_size;

    FORALL i IN 1..l_data.COUNT
    INSERT INTO t2 VALUES l_data(i);

    EXIT WHEN c%NOTFOUND;
    END LOOP;
    CLOSE c;
END test_proc;
/

但我得到了以下错误,即使表存在并从我运行的模式中访问。

SQL> show errors
Errors for PROCEDURE :

LINE/COL ERROR
-------- -----------------------------------------------------------------
6/4      PL/SQL: Item ignored
6/34     PLS-00201: identifier 'WEB.SALESLINE' must be declared
11/7     PL/SQL: SQL Statement ignored
16/9     PL/SQL: ORA-00942: table or view does not exist
20/5     PL/SQL: SQL Statement ignored
20/40    PLS-00597: expression 'OBJECTTABLE$' in the INTO list is of wrong
         type

23/5     PL/SQL: SQL Statement ignored
23/27    PL/SQL: ORA-00904: : invalid identifier