<< Back to previous view

[QA-19] ORA-00600 [2845] in UPDATE. WRONG ROWID VALUE. Created: 15/Jul/07  Updated: 16/Sep/07

Status: Closed
Project: Questions & Answers
Fix Version/s: None

Type: Oracle - Internals Priority: Major
Reporter: ubTools Support Assignee: ubTools Support
Resolution: Answered Votes: 0

Product Version: 7.3.2.3.0
Operating System: HP-UX
Operating System Version: B.10.20

 Description   

Error code:

 
ORA-00600: internal error code, arguments: [2845], [0], [50], [39314], [], [], [], []

Current SQL statement for this session:

 
update pers_auth_str_tbl  set asgn_str=:b1 where rowid=:b2

Oracle kernel function from which the problem is raised:

 
kcfrbd()

This funtion is a funtion of Oracle's Cache Layer.

Values of bind variables:

 
:b1 = 0
:b2 = "9992"

Data types of bind variables:

 
:b1 : Number
:b2 : Varchar2

Problem explanation:

As you see, your ROWID value in :b2 is "9992". This is incorrect. ROWID format in Oracle7 is 'BBBBBBBB.SSSS.FFFF' (Block.Slot.File).

Bug:

Check Bug#632396. This bug says:

  • The correct behaviour is to return an "Invalid Rowid" message.

Recomendation:

Use proper datatype in the bind variable.


Generated at Mon Sep 15 23:28:01 UTC 2025 using JIRA Standard Edition, Version: 3.12.3-#302.