ORA-01480: trailing null missing from STR bind value Cause: A bind variable of type 5 (null-terminated string) does not contain the terminating null in its buffer. Action: Terminate the string with a null character ORA-01480: trailing null missing from STR bind value: The column that is being read has a value which is too large to […]
Oracle/PLSQL: ORA-00905 Learn the cause and how to resolve the ORA-00905 error message in Oracle. Description When you encounter an ORA-00905 error, the following error message will appear: ORA-00905: missing keyword Cause You tried to execute a statement, but you missed a required keyword. Resolution The option(s) to resolve this Oracle error are: Option #1 […]
Oracle/PLSQL: ORA-00903 Learn the cause and how to resolve the ORA-00903 error message in Oracle. Description When you encounter an ORA-00903 error, the following error message will appear: ORA-00903: invalid table name Cause You tried to execute a SQL statement that included an invalid table name or the table name does not exist. Resolution The […]
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 […]
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: […]
Oracle/PLSQL: ORA-00401 Learn the cause and how to resolve the ORA-00401 error message in Oracle. Description When you encounter this error, the following error message will appear: ORA-00401: the value for parameter name is not supported by this release Cause You tried to specify a value in the initialization file that is not supported by […]
Oracle/PLSQL: ORA-00361 Learn the cause and how to resolve the ORA-00361 error message in Oracle. Description When you encounter an ORA-00361 error, the following error message will appear: ORA-00361: cannot remove last log member name group num Cause You tried to remove the last member of a redo log group. Resolution The option(s) to resolve […]
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 […]
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) […]
Oracle/PLSQL: ORA-00301 Learn the cause and how to resolve the ORA-00301 error message in Oracle. Description When you encounter an error, the following error message will appear: ORA-00301: error in adding log file <name> – file cannot be created Cause You tried to create a redo log file, but the creation failed. Resolution The option(s) […]
