Parenthesis

How to Resolve ORA-00026: missing or invalid session ID

by Ed Chen
January 16, 2023December 26, 2022

ORA-00026 Tried to kill a session in a database, but it failed with ORA-00026. Case 1 SQL> ALTER SYSTEM KILL SESSION ('391, 9220'); ALTER SYSTEM… Read More »

ORA-06502 due to Character Type Conversion

How to Resolve ORA-06502: PL/SQL: numeric or value error: character to number conversion error

by Ed Chen
May 26, 2019December 10, 2022
6 Comments

ORA-06502 ORA-06502 means that PL/SQL engine cannot convert a character-typed string into a number or a subset of arithmetic for overall evaluation. Mostly, it's because… Read More »