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.