Error code
|
Description
|
---|---|
SQL Error 1
|
Parsing error 'syntax error'
The SQL parser could not parse the SQL string. Check the syntax of the SQL statement and try again.
|
SQL Error 2
|
Table table can not be opened
You may not have privileges to access the table and its data.
|
SQL Error 3
|
Table table can not be created
Table can not be created. You may not have privileges for this operation.
|
SQL Error 4
|
Illegal type definition column
A column type in your CREATE TABLE statement is illegal. Use a legal type for the column.
|
SQL Error 5
|
Table table can not be dropped
Table can not be dropped. Only the owner (that is, the creator) can drop it.
|
SQL Error 6
|
Illegal value specified for column column
The value specified for column is invalid. Check the value for the column.
|
SQL Error 7
|
Insert failed
The server failed to do the insertion. You may not have INSERT privilege on the table or it may be locked.
|
SQL Error 8
|
Delete failed
The server failed to do the deletion. You may not have DELETE privilege on the table or the row may be locked.
|
SQL Error 9
|
Row fetch failed
The server failed to fetch a row. You may not have SELECT privilege on the table or there may be an exclusive lock on the row.
|
SQL Error 10
|
View view can not be created
You cannot create this view. You may not have SELECT privilege on one or more tables in the query-specification of your CREATE VIEW statement.
|
SQLError 11
|
View view cannot be dropped.
You cannot drop this view. Only the owner (i.e. the creator) of the view can drop it.
|
SQLError 12
|
Illegal view definition view
The view definition is illegal. Check the syntax of the definition.
|
SQLError 13
|
Illegal column name column
Column name is illegal. Check that the name is not a reserved name.
|
SQL Error 14
|
Call to function function failed
Function call to function failed. Check the arguments and their types.
|
SQL Error 15
|
Arithmetic error
An arithmetical error occurred. Check the operators, values and types.
|
SQL Error 16
|
Update failed
The server failed to update a row. There may a lock on a row.
|
SQL Error 17
|
View is not updatable
This view is not updatable. UPDATE, INSERT and DELETE operations are not allowed.
|
SQL Error 18
|
Inserted row does not meet check option condition
You tried to insert a row, but one or more of the column values do not meet column constraint definition.
|
SQL Error 19
|
Updated row does not meet check option condition
You tried to update a row, but one or more of the column values do not meet column constraint definition.
|
SQL Error 20
|
Illegal CHECK constraint
A check constraint given to the table is illegal. Check the types of the check constraint of this table.
|
SQL Error 21
|
Insert failed because of CHECK constraint
You tried to insert a row, but the values do not meet the check option conditions.
|
SQL Error 22
|
Update failed because of CHECK constraint
You tried to update a row, but the values do not meet the check option conditions.
|
SQL Error 23
|
Illegal DEFAULT value
The DEFAULT value for the column given is illegal.
|
SQL Error 25
|
Duplicate columns in INSERT column list
You have included a column in column list twice. Remove duplicate columns.
|
SQL Error 26
|
At least one column definition required in CREATE TABLE
You need to specify at least one column definition in a CREATE TABLE statement.
|
SQL Error 27
|
Illegal REFERENCES column list
There are wrong number of columns in your REFERENCES list.
|
SQL Error 28
|
Only one PRIMARY KEY allowed in CREATE TABLE You can use only one PRIMARY KEY in CREATE TABLE.
|
SQL Error 29
|
GRANT failed
Granting privileges failed. You may not have privileges for this operation.
|
SQL Error 30
|
REVOKE failed
Revoking privileges failed. You may not have privileges for this operation.
|
SQL Error 31
|
Multiple instances of a privilege type
You tried to grant privileges to a role or a user. You have included multiple instances of a privilege type in the list of privileges.
|
SQL Error 32
|
Illegal constant constant
Illegal constant was found. Check the syntax of the statement.
|
SQL Error 33
|
Column name list of illegal length
You have entered different number of columns in CREATE VIEW statement to the view and to the table.
|
SQL Error 34
|
Conversion between types failed
An expression in UPDATE statement has illegal type for a column.
|
SQL Error 35
|
Column names not allowed in ORDER BY for UNION
You can not use column name in an ORDER BY for UNION statement.
|
SQL Error 36
|
Nested aggregate functions
Nested aggregate functions can not be used. For example: SUM(AVG(column)).
|
SQL Error 37
|
Aggregate function with no arguments
An aggregate function was entered with no arguments. For example: SUM().
|
SQL Error 38
|
Set operation between different row types
You have tried to execute a set operation of tables with incompatible row types. The row types in a set operation must be compatible.
|
SQL Error 39
|
COMMIT WORK failed Committing a transaction failed.
|
SQL Error 40
|
ROLLBACK WORK failed Rolling back a transaction failed.
|
SQL Error 41
|
Savepoint could not be created A savepoint could not be created.
|
SQL Error 42
|
Could not create index index
An index could not be created. You may not have privileges for this operation. You need to be an owner of the table or have SYS_ADMIN_ROLE to have privileges to create index for the table.
|
SQL Error 43
|
Could not drop index index
An index could not be dropped. You may not have privileges for this operation. You need to be an owner of the table or have SYS_ADMIN_ROLE to have privileges to drop index from the table.
|
SQL Error 44
|
Could not create schema schema A schema could not be created.
|
SQL Error 45
|
Could not drop schema schema A schema could not be dropped.
|
SQL Error 46
|
Illegal ORDER BY specification
You tried to use an ORDER BY column that does not exist. Refer to an existing column in the ORDER BY specification.
|
SQL Error 47
|
Maximum length of identifier is 31
You have exceeded the maximum length for the identifier.
|
SQL Error 48
|
Subquery returns more than one row
You have used a subquery that returns more than one row. Only subqueries returning one row may be used in this situation.
|
SQL Error 49
|
Illegal expression expression
You tried to insert or update a table using an aggregate function (SUM, MAX, MIN or AVG) as a value. This is not allowed.
|
SQL Error 50
|
Ambiguous column name column
You have referenced a column which exists in more than one table. Use syntax table.column to indicate which table you want to use.
|
SQL Error 51
|
Non-existent function function
You tried to use a function which does not exist.
|
SQL Error 52
|
Non-existent cursor cursor
You tried to use a cursor which is not created.
|
SQL Error 53
|
Function call sequence error
A function was called in wrong order. Check the sequence and success of the function calls.
|
SQL Error 54
|
Illegal use of a parameter
A parameter was used illegally. For example: SELECT * FROM TEST WHERE ? < ?;
|
SQL Error 55
|
Illegal parameter value
A parameter has an illegal value. Check the type and value of the parameter.
|
SQL Error 56
|
Only ANDs and simple condition predicates allowed in UPDATE CHECK All search condition predicates are not supported.
|
SQL Error 57
|
Opening the cursor did not succeed
Server failed to open a cursor. You may not have cursor open at this moment.
|
SQL Error 58
|
Column column is not referenced in group-by-clause
You tried to group rows using column. All columns in group_by_clause must be listed in your select_list. A star ('*') notation is not allowed with GROUP BY.
|
SQL Error 59
|
Comparison between incompatible types
You tried to compare values which have incompatible types. Incompatible types are for example an integer and a date value.
|
SQL Error 60
|
Reference to the insert table not allowed in the source query
You have referenced in subquery a table where you are inserting values. This is not allowed.
|
SQL Error 61
|
Reference to the update table not allowed in subquery
You have referenced in subquery a table where you are updating values. This is not allowed.
|
SQL Error 62
|
Reference to the delete table not allowed in subquery
You have referenced in subquery a table where you are deleting values. This is not allowed.
|
SQL Error 63
|
Subquery returns more than one column
You have used a subquery that returns more than one column. Only subqueries returning one column may be used.
|
SQL Error 64
|
Cursor cursor not updatable
The cursor opened is not updatable.
|
SQL Error 65
|
Insert or update tried on pseudo column
You tried to update a pseudo column (ROWID, ROWVER). Pseudo columns are not updatable.
|
SQL Error 66
|
Could not create user user
A user could not be created. You may not have privileges for this operation.
|
SQL Error 67
|
Could not alter user user
A user could not be altered. You may not have privileges for this operation.
|
SQL Error 68
|
Could not drop user user
A user could not be dropped. You may not have privileges for this operation.
|
SQL Error 69
|
Could not create role role
A role could not be created. You may not have privileges for this operation.
|
SQL Error 70
|
Could not drop role role
A role could not be dropped. You may not have privileges for this operation.
|
SQL Error 71
|
Grant role failed
Granting role failed. You may not have privileges for this operation.
|
SQL Error 72 Revoke role failed
|
Revoking role failed. You may not have privileges for this operation.
|
SQL Error 73
|
Comparison of vectors of different length
You have tried to compare row value constructors that have different number of dimensions. For example you have compared (a,b,c) to (1,1).
|
SQL Error 74
|
Expression * not compatible with aggregate expression
The aggregate expression can not be used with * columns. Specify columns using their names when used with this aggregate expression. This usually happens when GROUP BY expression is used with the * columns.
|
SQL Error 75
|
Illegal reference to table table
You have tried to reference a table which is not in the FROM list. For example: SELECT T1.* FROM T2.
|
SQL Error 76
|
Ambiguous table name table
You have used the syntax table.column_name ambiguously. For example: SELECT T1.* FROM T1 A,T1 B WHERE A.F1=0;
|
SQL Error 77
|
Illegal use of aggregate expression
You tried to use aggregate expression illegally. For example: SELECT ID FROM TEST WHERE SUM(ID) = 3;
|
SQL Error 78
|
Row fetch failed
The server failed to fetch a row. You may not have SELECT privilege on the table or there may be an exclusive lock on the row.
|
SQL Error 79
|
Subqueries not allowed in CHECK constraint You tried to use subquery in a check constraint.
|
SQL Error 80
|
Sorting failed
External sorter is out of disk space or cache memory. Modify parameters in configuration file solid.ini.
|
SQL Error 81
|
SET syntax results in error
|
SQL Error 82
|
Improper type used with LIKE
|
SQL Error 83
|
Syntax error
|
SQL Error 84
|
Parser error statement
|
SQL Error 85
|
Incorrect number of values for INSERT
|
SQL Error 86
|
Illegal ROWNUM constraint
|
SQL Error 88
|
Subquery not allowed in UPDATE expression Subqueries cannot be used with UPDATE statements.
|
SQL Error 90
|
Incorrect ALTER table
|
SQL Error 93
|
Illegal GROUP BY expression GROUP BY expression is illegal.
|
SQL Error 102
|
Unused optimizer hint
A table name alias was used in the query, but this alias was not specified as the table name in the optimizer hint. The alias name must be specified, not the table name.
|