SAP OPENSQL EXCEPTIONS documentation, setup help and usage info

Open SQL � Exceptions

Catchable Exceptions
CX_SY_OPEN_SQL_DB

Reason for error: A general database error occurred.

Runtime error: DBIF_RSQL_SQL_ERROR

Reason for error: Error in module RSQL of the database interface.

Runtime error: DBIF_RSQL_INVALID_RSQL

Reason for error: No data found for the specified key.

Runtime error: DBIF_RSQL_KEY_NOT_FOUND

Reason for error: Unexpected end of data when accessing a table.

Runtime error: DBIF_RSQL_END_OF_DATA

Reason for error: The key for a table was not completely specified.

Runtime error: DBIF_RSQL_KEY_NOT_SPECIFIED

Reason for error: Es soll ein Datensatz eingef�gt werden, obwohl auf der

Datenbank bereits ein Datensatz mit dem gleichen Schl�ssel existiert.

Runtime error: DBIF_RSQL_KEY_ALREADY_EXISTS

Reason for error: An invalid database cursor was used.

Runtime error: DBIF_RSQL_INVALID_CURSOR

Reason for error: An attempt was made to access a closed database cursor.

Runtime error: SAPSQL_SQLS_INVALID_CURSOR

CX_SY_DYNAMIC_OSQL_SEMANTICS

Reason for error: The database column whose values are to be aggregated does not have a numeric type.

Runtime error: SAPSQL_HAVING_AVG_TYPE

Reason for error: The database column whose values are to be aggregated does not have a numeric type.

Runtime error: SAPSQL_HAVING_SUM_TYPE

Reason for error: Search pattern not specified in a character literal.

Runtime error: SAPSQL_LIKE_VAL_TYPE

Reason for error: A token cannot be interpreted as a literal or in the current context of valid variable names.

Runtime error: SAPSQL_WHERE_ILLEGAL_VALUE and

SAPSQL_SET_ILLEGAL_VALUE

Reason for error: A table name is too long.

Runtime error: SAPSQL_TABNAME_TOO_LONG

Runtime error: A field name is too long.

Runtime error: SAPSQL_FIELDNAME_TOO_LONG

Reason for error: No table exists with the specified name.

Runtime error: SAPSQL_INVALID_TABLENAME

Reason for error: A field name is ambiguous.

Runtime error: SAPSQL_AMBIGUOUS_FIELDNAME

Reason for error: No column exists with the specified name.

Runtime error: SAPSQL_INVALID_FIELDNAME

Reason for error: The specified table is not declared as a table or view in ABAP Dictionary.

Runtime error: SAPSQL_NO_DBTAB_OR_VIEW

Reason for error: An attempt was made to select the sum of a non-numeric field.

Runtime error: SAPSQL_FIELDLIST_SUM_TYPE

Reason for error: An attempt was made to select the average of a non-numeric field.

Runtime error: SAPSQL_FIELDLIST_AVG_TYPE

Reason for error: An attempt was made to create an aggregate function using a LOB column .

Runtime error: SAPSQL_AGGREGATE_LOB

Reason for error: An attempt was made to sort the values of a LOB column .

Runtime error: SAPSQL_ORDER_BY_LOB

Reason for error: An attempt was made to use the addition DISTINCT

on a LOB column .

Runtime error: SAPSQL_DISTINCT_AND_LOB

Reason for error: An alias is too long.

Runtime error: SAPSQL_ALIASNAME_TOO_LONG

Reason for error: An attempt was made to group by the values of a LOB column .

Runtime error: SAPSQL_GROUP_BY_LOB

Reason for error: An attempt was made to use a LOB column in a logical expression.

Runtime error: SAPSQL_BOUND_LONG_STRING

Reason for error: A pattern specified with LIKE is too long.

Runtime error: SAPSQL_LIKE_PATTERN_TOO_LONG and

SAPSQL_LIKE_PATTERN_TOO_LONG

Reason for error: An attempt was made to select from a non-transparent table using the addition DISTINCT .

Runtime error: SAPSQL_ILLEGAL_DISTINCT

Reason for error: A field, whose value is to be changed with + or - , has a non-numeric type

Runtime error: SAPSQL_SET_PLUS_MINUS_TYPE

Reason for error: LIKE is used with the addition ESCAPE on a pooled table.

Runtime error: SAPSQL_ESCAPE_WITH_POOLTABLE

Reason for error: A pooled table or cluster table is to be read using a secondary database connection .

Runtime error: SAPSQL_CONNECTION_ILL_TABTYPE

CX_SY_DYNAMIC_OSQL_SYNTAX

Reason for error: The keyword AND is missing after the lower comparison value of BETWEEN .

Runtime error: SAPSQL_BETWEEN_MISSING_AND

Reason for error: The logical expression has incorrect parentheses.

Runtime error: SAPSQL_HAVING_PARENTHESES

Reason for error: An unknown aggregate function was found.

Runtime error: SAPSQL_ILLEGAL_AGGREGATE

Reason for error: The operator IS NULL is not followed by the keyword NULL .

Runtime error: SAPSQL_ILLEGAL_IS_NULL

Reason for error: The operator IN has incorrect parentheses.

Runtime error: SAPSQL_IN_ILLEGAL_LIST

Reason for error: The logical expression contains a text field literal that does not have a closing quotation mark.

Runtime error: SAPSQL_LIKE_QUOTES

Reason for error: The logical expression ends unexpectedly.

Runtime error: SAPSQL_MISSING_LOG_CONDITION

Reason for error: The Escape character is missing after the addition ESCAPE .

Runtime error: SAPSQL_WHERE_MISSING_ESCAPE

Reason for error: An operator is missing in the logical expression.

Runtime error: SAPSQL_WHERE_MISSING_OPERATOR

Reason for error: A literal or name of an ABAP variable is missing in the logical expression.

Runtime error: SAPSQL_WHERE_MISSING_VALUE

Reason for error: The logical expression has incorrect parentheses.

Runtime error: SAPSQL_WHERE_PARENTHESES

Reason for error: The logical expression contains a text field literal that does not have a closing quotation mark.

Runtime error: SAPSQL_WHERE_QUOTES

Reason for error: An unknown operator is used in the logical expression.

Runtime error: SAPSQL_WHERE_UNKNOWN_OPERATOR

Reason for error: An alias is missing.

Runtime error: SAPSQL_MISSING_ALIAS

Reason for error: A column from the right side of a LEFT OUTER JOIN

is used in a WHERE condition.

Runtime error: SAPSQL_ACCESS_TO_RHS_TABLE

Reason for error: Syntax error when the addition

CREATING was specified dynamically.

Runtime error: SAPSQL_NO_LOB_COLUMN

Runtime error: SAPSQL_FOR_ALL_COLUMNS

Runtime error: SAPSQL_TWICE_DEFINITION

Runtime error: SAPSQL_UNION_POSSIBLE

Runtime error: SAPSQL_MISSING_FOR_COLUMNS

Runtime error: SAPSQL_OTHER_ONLY_AT_THE_END

The following exceptions can only occur when using the statement
UPDATE :

Reason for error: An attempt was made to change a database field using an operator other than + or - .

Runtime error: SAPSQL_SET_NOT_PLUS_MINUS

Reason for error: An unknown operator was used in the statement SET

Runtime error: SAPSQL_SET_UNKNOWN_OPERATOR

Reason for error: A literal or name of an ABAP variable is missing in the statement SET .

Runtime error: SAPSQL_SET_MISSING_VALUE

Reason for error: The statement SET contains a text field literal, for which there is no closing quotation mark..

Runtime error: SAPSQL_SET_QUOTES

Non-catchable Exceptions

Reason for error: Invalid call of the database interface.

Runtime error: DBIF_RSQL_INVALID_REQUEST

Reason for error: Insufficient memory is available for the statement.

Runtime error: DBIF_RSQL_NO_MEMORY

Reason for error: Data area passed is too short for access to the table.

Runtime error: DBIF_RSQL_BUFFER_TOO_SHORT

Reason for error: The structure of a table is inconsistent with the dictionary.

Runtime error: DBIF_RSQL_DDIC_INCONSISTENT

Reason for error: The sort order specified for a table is not possible.

Runtime error: DBIF_RSQL_SORT_ORDER

Reason for error: Error when accessing the buffer of a table.

Runtime error: DBIF_RSQL_BUFFER_ERROR

Reason for error: A table is not known or does not exist.

Runtime error: DBIF_RSQL_TABLE_UNKNOWN

Reason for error: Internal error when accessing a table.

Runtime error: DBIF_RSQL_INTERNAL_ERROR

Reason for error: Unexpected return code when accessing a table.

Runtime error: DBIF_RSQL_UNEXPECTED_CODE

SAP OPENSQL EXCEPTIONS documentation, setup help and example usage