Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

table of varchar2(32000) error

651325Jul 22 2008 — edited Jul 22 2008
Oracle 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 ??
---------------------------------------------------------------------------
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2008
Added on Jul 22 2008
9 comments
3,528 views