ORA-01465 Error Message
Learn the cause and how to resolve the ORA-01465 error message in Oracle.
Description
When you encounter an ORA-01465 error, the following error message will appear:
- ORA-01465: invalid hex number
Cause
You tried to reference a ROWID, but it contained invalid characters.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
This error generally occurs when you perform an UPDATE after a SELECT FOR UPDATE statement. Examine the ROWID value returned from the SELECT FOR UPDATE and enter the value in the exactly the same format and surrounded by single quotes.
No comments:
Post a Comment