Parenthesis

How to Resolve ORA-00907: missing right parenthesis

by Ed Chen
May 2, 2023March 25, 2023

ORA-00907 ORA-00907 means that SQL parser saw an illegal string or expression where it expects a right parenthesis to close the inner statement. Usually, it's… Read More »

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 »

JavaScript is not enabled. Please enable it and reload the page.