History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: QA-19
Type: Oracle - Internals Oracle - Internals
Status: Closed Closed
Resolution: Answered
Priority: Major Major
Assignee: ubTools Support
Reporter: ubTools Support
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Questions & Answers

ORA-00600 [2845] in UPDATE. WRONG ROWID VALUE.

Created: 15/Jul/07 05:08 PM   Updated: 16/Sep/07 04:27 PM
Fix Version/s: None

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


 Description  « Hide

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.



 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.