XStream Outbound crash with OCI-21500[knclprstr:str] when process large volumn insert on linux64
create table bigtable
(
Col0 int not null,
Col1 VARCHAR2(30) not null,
Col2 VARCHAR2(30) not null,
… -- totally 67 columns
Col66 VARCHAR2(30) not null
)
Then you try to insert 10000 rows into the table with n rows per transaction.
Insert into bigtable (…) values(0,’xx…x’, …
You can simply fill all the varchar2 columns with 30 characters.
And then start XStream out to fetch LCR. After a while(7000 or 8000 rows?) the following exception will be thrown.
OCI-21500: internal error code, arguments: [knclprstr:str], [0], [stmt_knglxr], [], [], [], [], []
I cannot find clue on website for this internal error.
Any suggestion?