table of varchar2(32000) error
651325Jul 22 2008 — edited Jul 22 2008Oracle Std.Edition 10.2.0.4.0
NLS_CHARACTERSET AL32UTF8
NLS_LENGTH_SEMANTICS database:Byte instance:Char session:Char
---------------------------------------------------------------------------
the following test creates error 00600:
DROP TYPE TEST.TSSTRINGLIST
/
CREATE OR REPLACE type TSStringList is table of varchar2(32000)
/
declare
sl TSStringList := TSStringList();
res TSStringList := TSStringList();
begin
sl.extend(1);
sl(sl.count) := 'hallo 1';
sl.extend(2);
sl(sl.count) := 'hallo 2';
sl.extend(3);
sl(sl.count) := 'hello 3';
select column_value bulk collect into res from table(sl);
end;
------------------------------------------------
Line 1: ORA-00600: Interner Fehlercode, Argumente: [mal0-size-too-large], [bfo_qeeOpn: qkexrXformOpn_InitOpn], [], [], [], [], [], []
ORA-06512: in Zeile 14
---------------------------------------------------------------------------
up to varchar2 (24000) or with NLS_LENGTH_SEMANTICS database:Byte instance:byte session:byte it works without problems;
whats wrong ??
---------------------------------------------------------------------------