TOracleObject (big ObjElements array)

A

AndreyB

Member²
I've got some object view in my database (Personal Oracle 8i NT) with the structure Invoice->Invoice Items. When I fill up the document in the client application (DOA 3.3.1) and amount of items per invoice exceeds 100 I've got error message during the flush of the modified object:
'OCI-21500: internal error code, arguments:
[kope2pic798], [], [], [], [], [], [], []
Is there any restrictions for the ObjElements array size or what is the problem?
BTW I have tried others OV and got the same result and sometimes that error hang up the Oracle Instance.
 
I'm not aware of any restriction in the TOracleObject code. What is the definition of the objects? Is it always a limit of exactly 100 elements?

------------------
Marco Kalter
Allround Automations
 
I can't say that it's exactly 100 records, in my case it happens occasionaly when the amounts of records slightly exceed 100, let say 102-110.
The definition of object is:
create or replace type Adj_Qty_Type as object
(
Item_No number(4),
Store_Id number(4),
Qty number(15,4)
)
/
create or replace type Adj_Qty_Tab as table of Adj_Qty_Type
/
create or replace type Adj_Item_Type as object
(
Item_No number(4),
Item_Sid number(20),
Orig_Value number(15,4),
Adj_Value number(15,4)
)
/
create or replace type Adj_Item_Tab as table of Adj_Item_Type
/
create or replace type Adjustment_Type as object
(
Adj_Sid number(20),
Sbs_Id number(4),
Store_Id number(4),
Adj_No number(9),
Adj_Type number(4),
Creating_Doc_No number(9),
Creating_Doc_Type number(4),
Clerk_Id number(9),
Price_Lvl number(4),
Workstation number(4),
Status number(9),
Reason_Id number(9),
Use_Vat number(1),
Created_Date date,
Modified_Date date,
Post_Date date,
-- Detail records
Adj_Items Adj_Item_Tab,
Adj_Qtys Adj_Qty_Tab,
Adj_Comments Comment_Tab
)
/

The OV is based on relational tables using Adjustment_Type. There are all necessary instead of triggers and everything worked fine until we encountered one document with a lot of details records (104 items). And this thing start to happen, I suspected that something wrong with that particular OV but when I tried to reproduce that situation with others OV with the similiar structure I got the same error. BTW the filling up the object is performed in the thread. Have anybody else reported anything like that before? May it be some glitch in the OCI libraries?
 
This problem looks remarkably similar to a problem I had recently with Oracle 8.1.6 when fetching large LOBS. The error text is almost identical in fact. This problem turned out to be due to a bug in OCI where a cache index pointer was out by a small amount ..... this bug has apparently been rectified by Oracle for the 8.1.7 release, but despite the fact that it was alos to be rolled into the 2nd patch release for 8.1.6, the problem still seems to be there.
frown.gif


This may be unrelated of course, but I would suggest you ask someone who has access to search for the error message text on Oracle's internal bug repository ....
 
You must log in or register to reply here.
Back
Top