Hi!

I keep getting error messages:

ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], []
ORA-06544: PL/SQL: internal error, arguments: [pfrrun.cfrbnd1()], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [0]

when I'm trying to execute following code:

DECLARE

TYPE t_collection IS TABLE OF T_TEST_TABLE%ROWTYPE;
l_collection t_collection := t_collection();
l_count NUMBER(38);

BEGIN

l_collection.EXTEND;
l_collection(1).TEXT_COL := 'aaaaa';
l_collection(1).NUMERIC_COL := 1;

SELECT count(*)
INTO l_count
FROM TABLE(l_collection);

END;
/

T_TEST_TABLE was created using:

CREATE TABLE T_TEST_TABLE (
TEXT_COL VARCHAR2 (100),
NUMERIC_COL NUMBER (38)
);

The error message suggests that there's something wrong with
the server, but what? Is there a known bug in this release
of Oracle DB?

Hilarion

PS.: How to use collection variables with 'IN' expression
(eg. SELECT * FROM t_table WHERE c_column IN l_collection),
specially when collection elements are of simple type
(eg. t_collection IS TABLE OF VARCHAR2(100))?

Wyslij mi plik z trace'm.

--
Krzysiek, Krakow