1

Parsing error 'syntax error'.

The SQL parser could not parse the SQL string. Check the syntax of the SQL statement and try again.

2

Table table can not be opened.

You might not have privileges to access the table and its data.

3

Table table can not be created.

Table can not be created. You might not have privileges for this operation.

4

Illegal type definition column.

A column type in your CREATE TABLE statement is illegal. Use a legal type for the column.

5

Table table can not be dropped.

Table can not be dropped. Only the owner (that is, the creator) can drop it.

6

Illegal value specified for column column.

The value specified for column is invalid. Check the value for the column.

7

Insert failed.

The server failed to do the insertion. You might not have INSERT privilege on the table or it might be locked.

8

Delete failed.

The server failed to do the deletion. You might not have DELETE privilege on the table or the row might be locked.

9

Row fetch failed.

The server failed to fetch a row. You might not have SELECT privilege on the table or there might be an exclusive lock on the row.

10

View view can not be created.

You cannot create this view. You might not have SELECT privilege on one or more tables in the query-specification of your CREATE VIEW statement.

11

View view cannot be dropped.

You cannot drop this view. Only the owner (that is, the creator) of the view can drop it.

12

Illegal view definition view.

The view definition is illegal. Check the syntax of the definition.

13

Illegal column name column name.

Column name is illegal. Check that the name is not a reserved name.

14

Call to function function failed.

Function call to function failed. Check the arguments and their types.

15

Arithmetic error.

An arithmetical error occurred. Check the operators, values and types.

16

Update failed.

The server failed to update a row. There might a lock on a row.

17

View is not updatable.

This view is not updatable. UPDATE, INSERT and DELETE operations are not allowed.

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.

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.

20

Illegal CHECK constraint.

A check constraint given to the table is illegal. Check the types of the check constraint of this table.

21

Insert failed because of CHECK constraint.

You tried to insert a row, but the values do not meet the check option conditions.

22

Update failed because of CHECK constraint.

You tried to update a row, but the values do not meet the check option conditions.

23

Illegal DEFAULT value.

The DEFAULT value for the column given is illegal.

25

Duplicate columns in INSERT column list.

You have included a column in column list twice. Remove duplicate columns.

26

At least one column definition required in CREATE TABLE.

You need to specify at least one column definition in a CREATE TABLE statement.

27

Illegal REFERENCES column list.

There are wrong number of columns in your REFERENCES list.

28

Only one PRIMARY KEY allowed in CREATE TABLE You can use only one PRIMARY KEY in CREATE TABLE.

29

GRANT failed.

Granting privileges failed. You might not have privileges for this operation.

30

REVOKE failed.

Revoking privileges failed. You might not have privileges for this operation.

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.

32

Illegal constant constant.

Illegal constant was found. Check the syntax of the statement.

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.

34

Conversion between types failed.

An expression in UPDATE statement has illegal type for a column.

35

Column names not allowed in ORDER BY for UNION.

You can not use column name in an ORDER BY for UNION statement.

36

Nested aggregate functions.

Nested aggregate functions can not be used. For example: SUM(AVG(column)).

37

Aggregate function with no arguments.

An aggregate function was entered with no arguments. For example: SUM().

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.

39

COMMIT WORK failed. Committing a transaction failed.

40

ROLLBACK WORK failed. Rolling back a transaction failed.

41

Savepoint could not be created. A savepoint could not be created.

42

Could not create index index.

An index could not be created. You might 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.

43

Could not drop index index.

An index could not be dropped. You might 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.

44

Could not create schema schema. A schema could not be created.

45

Could not drop schema schema. A schema could not be dropped.

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.

47

Maximum length of identifier is 31.

You have exceeded the maximum length for the identifier.

48

Subquery returns more than one row.

You have used a subquery that returns more than one row. Only subqueries returning one row might be used in this situation.

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.

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.

51

Non-existent function function.

You tried to use a function which does not exist.

52

Non-existent cursor cursor.

You tried to use a cursor which is not created.

53

Function call sequence error.

A function was called in wrong order. Check the sequence and success of the function calls.

54

Illegal use of a parameter.

A parameter was used illegally. For example: SELECT * FROM TEST WHERE ? < ?;

55

Illegal parameter value.

A parameter has an illegal value. Check the type and value of the parameter.

56

Only ANDs and simple condition predicates allowed in UPDATE CHECK All search condition predicates are not supported.

57

Opening the cursor did not succeed.

Server failed to open a cursor. You might not have cursor open at this moment.

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.

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.

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.

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.

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.

63

Subquery returns more than one column.

You have used a subquery that returns more than one column. Only subqueries returning one column might be used.

64

Cursor cursor not updateable.

The cursor opened is not updateable.

65

Insert or update tried on pseudo column.

You tried to update a pseudo column (ROWID, ROWVER). Pseudo columns are not updateable.

66

Could not create user user.

A user could not be created. You might not have privileges for this operation.

67

Could not alter user user.

A user could not be altered. You might not have privileges for this operation.

68

Could not drop user user.

A user could not be dropped. You might not have privileges for this operation.

69

Could not create role role.

A role could not be created. You might not have privileges for this operation.

70

Could not drop role role.

A role could not be dropped. You might not have privileges for this operation.

71

Grant role failed.

Granting role failed. You might not have privileges for this operation.

72

Revoke role failed.

Revoking role failed. You might not have privileges for this operation.

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).

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.

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.

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;

77

Illegal use of aggregate expression.

You tried to use aggregate expression illegally. For example: SELECT ID FROM TEST WHERE SUM(ID) = 3;

78

Row fetch failed.

The server failed to fetch a row. You might not have SELECT privilege on the table or there might be an exclusive lock on the row.

79

Subqueries not allowed in CHECK constraint. You tried to use subquery in a check constraint.

80

Sorting failed.

External sorter is out of disk space or cache memory. Modify parameters in configuration file solid.ini.

81

SET syntax results in error.

82

Improper type used with LIKE.

83

Syntax error.

84

Parser error statement.

85

Incorrect number of values for INSERT.

86

Illegal ROWNUM constraint.

88

Subquery not allowed in UPDATE expression. Subqueries cannot be used with UPDATE statements.

90

Incorrect ALTER table.

93

Illegal GROUP BY expression. GROUP BY expression is illegal.

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.