Precompilers and OCI (MOSC)

MOSC Banner

XStream Outbound crash with OCI-21500[knclprstr:str] when process large volumn insert on linux64

edited Oct 24, 2013 12:00AM in Precompilers and OCI (MOSC) 4 commentsAnswered
For example,
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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center