Category: Errors

Errors of Oracle Database

ORA-00902: invalid datatype

Oracle/PLSQL: ORA-00902 Learn the cause and how to resolve the ORA-00902 error message in Oracle. Description When you encounter an ORA-00902 error, the following error message will appear: ORA-00902: invalid datatype Cause You tried to execute a CREATE TABLE or ALTER TABLE statement that contained an invalid datatype. Resolution The option(s) to resolve this Oracle […]

ORA-00900: invalid SQL statement

Oracle/PLSQL: ORA-00900 Learn the cause and how to resolve the ORA-00900 error message in Oracle. Description When you encounter an ORA-00900 error, the following error message will appear: ORA-00900: invalid SQL statement Cause The statement that you’ve tried to execute is not a valid SQL statement. Resolution The option(s) to resolve this Oracle error are: […]

ORA-01722: invalid number

Oracle/PLSQL: ORA-01722 Learn the cause and how to resolve the ORA-01722 error message in Oracle. Description When you encounter an error, the following error message will appear: ORA-01722: invalid number Cause You executed a SQL statement that tried to convert a string to a number, but it was unsuccessful. Resolution The option(s) to resolve this […]

ORA-00304: requested INSTANCE_NUMBER is busy

Oracle/PLSQL: ORA-00304 Learn the cause and how to resolve the ORA-00304 error message in Oracle. Description When you encounter an ORA-00304 error, the following error message will appear: ORA-00304: requested INSTANCE_NUMBER is busy Cause You tried to start an Oracle instance by using an INSTANCE_NUMBER parameter value that is already in use. Resolution The option(s) […]

ORA-00107: failed to connect to network listener process

Oracle/PLSQL: ORA-00107 Learn the cause and how to resolve the ORA-00107 error message in Oracle. Description When you encounter an ORA-00107 error, the following error message will appear: ORA-00107: failed to connect to network listener process Cause The network listener process was not been successfully started. Resolution The option(s) to resolve this Oracle error are: […]