Chapter 30. 70000 ~ 70999

70001: SQL buffer is empty.

CauseThe SQL buffer is empty.
ActionRetry the command after executing a SQL statement multiple iterations.

70002: Failed to open the file '%1$s': %2$s.

CauseFailed to open the file.
ActionCheck the file name and path.

70003: Invalid command. Enter HELP or HELP <command>.

CauseInvalid command.
ActionVerify the command is correct.

70004: Not connected to the server.

CauseNot connected to the server or connection was lost.
ActionVerify there is an active connection to the server.

70005: Invalid object name '%1$s'.

CauseAn object with the specified name was not found.
ActionVerify the object name is correct.

70006: Invalid schema name '%1$s'.

CauseThe specified schema name does not exist.
ActionVerify the schema name is correct.

70007: Invalid parameter name.

CauseThe environment variable specified for SET statement does not exist.
ActionVerify the variable name is correct.

70008: Invalid integer value.

CauseThe integer value is invalid for a SET environment variable.
ActionSpecify a positive integer value.

70009: Invalid string value.

CauseThe string value is invalid for a SET environment variable.
ActionSpecify a string value smaller than 128.

70010: Parameter accepts only ON or OFF as values.

CauseThe parameter accepts only ON or OFF as a value.
ActionMake sure to use ON or OFF for the parameter.

70011: Invalid parameter value or type.

CauseInvalid parameter value or type.
ActionCheck the parameter value or type.

70012: Failed to set AUTOCOMMIT mode.

CauseFailed to set AUTOCOMMIT mode.
ActionEnsure that the AUTOCOMMIT mode is correct.

70013: No modifications to be saved.

CauseNothing was modified, so no changes will be saved.
ActionUse the command after performing the SQL statement more than once.

70014: BLOB type cannot be displayed by SQL utility.

CauseThe SQL utility cannot display BLOB data.
ActionCheck to see if it contains a BLOB type.

70016: New password and confirmation password do not match.

CauseThe password that was re-entered for confirmation does not match the new password.
ActionEnsure the confirmation password was typed correctly.

70017: Missing or invalid password.

CauseThe password is missing or invalid.
ActionVerify that the correct password was provided.

70018: Invalid AUTOTRACE mode.

CauseInvalid AUTOTRACE mode.
ActionVerify the AUTOTRACE mode is correctly specified.

70019: Unable to describe invalid object.

CauseCannot describe an invalid object.
ActionVerify the object is valid.

70020: Specified object was not found.

CauseThe object does not exist.
ActionVerify that the object exists.

70021: Unable to set SERVEROUTPUT mode.

CauseFailed to specify a SERVEROUTPUT environment variable.
ActionVerify the DBMS_OUTPUT package exists.

70022: Not yet implemented.

CauseThis function has yet to be implemented.
ActionThis function will be supported in the next version.

70023: Unable to set AUTOTRACE mode.

CauseFailed to specify an AUTOTRACE environment variable.
ActionContact the technical support team.

70024: Invalid format '%1$s'.

CauseInvalid format type.
ActionRefer to "SQL Reference Guide" to check the validity of the format.

70025: Password is too long.

CauseThe password must be less than or equal to 64 characters.
ActionChoose a new password.

70026: Filename is too long.

CauseThe file name must be less than or equal to 256 characters.
ActionChoose a new filename.

70027: Unable to execute shell command.

CauseCannot execute the shell command.
ActionRefer to "Administrator Guide" to check the validity of the shell command.

70028: Invalid shutdown mode.

CauseInvalid shutdown mode.
ActionRefer to "Administrator Guide" to check the validity of the shutdown mode.

70029: Database name is too long.

CauseThe DB name must be less than or equal to 40 characters.
ActionChoose a new DB name.

70034: Stat table creation failed.

CauseFailed to create a stat table.
ActionCheck the user's permissions for table creation.

70035: Unable to display plan: check PLUSTRACE role.

CauseFailed to display the plan of the SQL statement.
ActionA PLUSTRACE role must be specified.

70036: Unable to gather statistics: check PLUSTRACE role.

CauseFailed to display statistics.
ActionA PLUSTRACE role must be specified.

70037: Missing or invalid username.

CauseThe user name is missing or invalid.
ActionA user name must be at least one character long.

70038: Username is too long.

CauseThe user name must be less than or equal to 128 characters.
ActionChoose a new username..

70039: Number is invalid or out of range.

CauseThe number is invalid or not an integer.
ActionUse an integer that is within the allowed range.

70040: HELP for '%1$s' does not exist.

CauseThere is no HELP for the subject.
ActionTry another subject.

70041: Invalid first or last line number.

CauseThe first or last line number is invalid.
ActionCheck the line value.

70042: Internal error occurred '%1$s'.

CauseAn internal error occurred.
ActionContact the technical support team.

70043: Undeclared variable '%1$s'.

CauseUndeclared variable.
ActionVerify that the variable name is correct.

70044: Invalid type.

CauseAn invalid type was used.
ActionRefer to "SQL Reference Guide" to verify the validity of the type.

70045: Declared variable was not found.

CauseThe declared variable was not found.
ActionDeclare the variable first.

70047: Input is too long.

CauseThe entered value must be less than or equal to 128 characters.
ActionRe-enter the input.

70048: Invalid bind parameter '%1$s'.

CauseInvalid bind variable.
ActionVerify that the name or type of the bind variable is correct.

70050: Format value is too long.

CauseThe format value must be less than or equal to 64 characters.
ActionRe-enter the format value.

70051: Environment variable is too long.

CauseThe environment variable must be less than or equal to 64 characters.
ActionChoose a new environment variable name.

70052: Not yet implemented.

CauseThis function has yet to be implemented.
ActionThis function will be supported in the next version.

70053: Invalid expression.

CauseInvalid expression.
ActionRefer to "SQL Reference Guide" to verify the validity of the expression.

70054: Pattern '%1$s' was not found.

CauseThe pattern does not exist in the current line.
ActionCheck if parts of the current line correspond to the pattern.

70055: Invalid column '%1$s'.

CauseInvalid column name.
ActionVerify that the column exists.

70056: Type constraint is out of range.

CauseType constraint is out of range.
ActionRefer to "SQL Reference Guide" to check the conditions for defining a type.

70057: Column '%1$s' does not fit on the line.

CauseThe column is too long to fit on the line.
ActionLengthen the line or shorten the column.

70058: Invalid use of DESCRIBE command.

CauseA DESCRIBE command cannot be used for a sequence.
ActionUse another command.

70059: Invalid option '%1$s'.

CauseInvalid option.
ActionSpecify a valid option.

70060: Failed to execute DESCRIBE [%1$d].

CauseFailed to execute a DESCRIBE command.
ActionCheck the error message.

70061: Failed to execute LS [%1$d].

CauseFailed to call the list of objects.
ActionCheck the error message.

70062: Failed to execute SHOW [%1$d].

CauseFailed to execute a SHOW command.
ActionCheck the error message.

70063: Failed to execute COUNT [%1$d].

CauseFailed to execute a COUNT command.
ActionCheck the error message.

70064: Substitution variable '%1$s' was not found.

CauseThe substitution variable was not found.
ActionDeclare a substitution variable first.

70065: Unterminated string.

CauseThe string is not terminated.
ActionCheck that quotation marks are used correctly.

70066: Operation is not allowed.

CauseThe operation is not allowed.
ActionCheck permissions.

70067: Environment variable '%1$s' is empty.

CauseAn empty environment variable is used.
ActionUse an environment variable containing a value.

70068: Failed to fetch a bind variable by using the RETURNING clause.

CauseFailed to fetch a bind variable by using the RETURNING clause.
ActionCheck the error message.

70069: Too many rows returned for the RETURNING clause.

CauseMore than one row returned for the RETURNING clause.
ActionUse a SQL statement that returns a single row.

70070: Invalid escape value.

CauseThe escape value is invalid for a SET environment variable.
ActionUse a symbol with a length of 1 excluding character, numeric, and blank characters.

70071: Invalid cursor identifier of the variable '%1$s'.

CausePreviously printed or invalid cursor identifier.
ActionSave the cursor identifier again.

70072: Variable name is too long.

CauseThe variable name must be less than or equal to 128 characters.
ActionChoose a new variable name.

70073: Integer value is out of range (%1$d..%2$d).

CauseThe integer value is out of range for a SET environment variable.
ActionSpecify a number within the range.

70074: Cannot recognize the wallet file.

CauseInput file name is incorrect or empty.
ActionCheck the environment variable, and verify the file name is correct.

70075: Failed to generate a security key.

CauseFailed to generate a security key.
ActionContact the technical support team.

70076: Unable to display the plan: Failed to retrieve the SQL ID to select the plan.

CauseFailed to retrieve the SQL ID of the last executed query in the current session.
ActionExecute the query again or contact the technical support team.

70077: The given value, '%1$s', does not match the format, '%2$s'.

CauseThe entered value does not match the predefined format.
ActionChange the format or modify the entered value.

70078: Unable to display plan: failed to retrieve the SQL ID.

CauseFailed to retrieve the SQL ID of the last executed query in the current session.
ActionExecute the query again or contact the technical support team.

70079: Invalid string value.

CauseThe length of the specified string in the SET command must be 1.
ActionModify the length of the string.

70080: Invalid character value.

CauseThe specified character in the SET command cannot be alphanumeric or white-space.
ActionModify the character value.

70081: Export format is too long.

CauseThe export format must be less than or equal to 16 characters.
ActionModify the format value.

70082: The '%1$s' command has been disabled.

CauseThe command has been disabled by the system administrator.
ActionContact the system administrator.

70083: The file '%1$s' already exists.

CauseThe specified file name already exists.
ActionEither overwrite or delete the existing file.

70084: Invalid variable name '%1$s'

CauseThe variable name must be alphanumeric and/or include underscores.
ActionModify the variable name.

70085: The variable '%1$s' is not a number.

CauseThe variable used in an EXIT command must be a number.
ActionUse a different number variable or change the existing value to a number.