Database Error Messages

An unexpected keyword was encountered in the SQL statement at or near the position printed in the error message. One of the following occurred:

1. You had a typo in your SQL statement.
2. Unsupported syntax was encountered for a clause in the statement.
3. An unsupported clause was encountered in the statement.
4. A string was terminated prematurely leading to the rest of the string to be interpreted as keywords. For example, an apostrophe in the string may be causing it to end prematurely.
5. If keyword_value does not appear in the statement and CURSOR_SHARING is set to FORCE, an unexpected bind variable was encountered in the statement.
6. If keyword_value does not appear in the statement and a function was invoked in the statement, an unexpected token was was encountered during function execution. This typically occurs when a function attempts to execute a statement it has constructed.

Take the action that corresponds with the Cause:

1. Check that your SQL statement has no typos.
2. Check Oracle Database documentation to find the correct syntax for the clause and update the problematic clause appropriately.
3. Check Oracle Database documentation to find the correct syntax for the statement and remove the unsupported clause.
4. Enter two single quotes instead of one to represent an apostrophe within a string.
5. Set CURSOR_SHARING to EXACT and execute the statement again. This may either resolve the issue or provide additional information regarding the error.
6. Check that the function is not executing a statement that contains any of the issues listed in Causes 1 through 5.

The SQL statement ends with an inappropriate clause. For example, an ORDER BY clause may have been included in a CREATE VIEW or INSERT statement. ORDER BY cannot be used to create an ordered view or to insert in a certain order.

Correct the syntax by removing the inappropriate clauses. It may be possible to duplicate the removed clause with another SQL statement. For example, to order the rows of a view, do so when querying the view and not when creating it. This error can also occur in SQL*Forms applications if a continuation line is indented. Check for indented lines and delete these spaces.

The SQL statement ends with an inappropriate clause. For example, an ORDER BY clause may have been included in a CREATE VIEW or INSERT statement. ORDER BY cannot be used to create an ordered view or to insert in a certain order.

Correct the syntax by removing the inappropriate clauses. It may be possible to duplicate the removed clause with another SQL statement. For example, to order the rows of a view, do so when querying the view and not when creating it. This error can also occur in SQL*Forms applications if a continuation line is indented. Check for indented lines and delete these spaces.