Skip to content

ABAP Keyword Documentation →  ABAP - Reference →  Processing External Data →  ABAP Database Accesses →  Open SQL 

Open SQL - Exceptions

Other versions: 7.31 | 7.40 | 7.54


Catchable Exceptions

CX_SY_OPEN_SQL_DB

  • Cause: A general database error occurred.
    Runtime error: DBIF_RSQL_SQL_ERROR
  • Cause: Error in module RSQL of the database interface.
    Runtime error: DBIF_RSQL_INVALID_RSQL
  • Cause: No data found for the specified key.
    Runtime error: DBIF_RSQL_KEY_NOT_FOUND
  • Cause: Unexpected end of data when accessing a table.
    Runtime error: DBIF_RSQL_END_OF_DATA
  • Cause: The key for a table was not completely specified.
    Runtime error: DBIF_RSQL_KEY_NOT_SPECIFIED
  • Cause: An invalid database cursor was used.
    Runtime Error: DBIF_RSQL_INVALID_CURSOR
  • Cause: An attempt was made to access a closed database cursor.
    Runtime Error: SAPSQL_SQLS_INVALID_CURSOR

CX_SY_DYNAMIC_OSQL_SEMANTICS

  • Cause: The database column whose values are to be aggregated does not have a numeric type.
    Runtime Error: SAPSQL_HAVING_AVG_TYPE
  • Cause: The database column whose values are to be aggregated does not have a numeric type.
    Runtime Error: SAPSQL_HAVING_SUM_TYPE
  • Cause: Search pattern not specified in a character literal.
    Runtime Error: SAPSQL_LIKE_VAL_TYPE
  • Cause: 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
  • Cause: 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
  • Cause: No table exists with the specified name.
    Runtime Error: SAPSQL_INVALID_TABLENAME
  • Cause: A field name is ambiguous.
    Runtime Error: SAPSQL_AMBIGUOUS_FIELDNAME
  • Cause: No column exists with the specified name.
    Runtime Error: SAPSQL_INVALID_FIELDNAME
  • Cause: The specified table is not declared as a table or view in ABAP Dictionary.
    Runtime Error: SAPSQL_NO_DBTAB_OR_VIEW
  • Cause: An attempt was made to select the sum of a non-numeric field.
    Runtime Error: SAPSQL_FIELDLIST_SUM_TYPE
  • Cause: An attempt was made to select the average of a non-numeric field.
    Runtime Error: SAPSQL_FIELDLIST_AVG_TYPE
  • Cause: An attempt was made to create an aggregate function using a LOB column.
    Runtime Error: SAPSQL_AGGREGATE_LOB
  • Cause: An attempt was made to sort the values of a LOB column.
    Runtime Error: SAPSQL_ORDER_BY_LOB
  • Cause: An attempt was made to use the addition DISTINCT on a LOB column.
    Runtime Error: SAPSQL_DISTINCT_AND_LOB
  • Cause: An alias is too long.
    Runtime Error: SAPSQL_ALIASNAME_TOO_LONG
  • Cause: An attempt was made to sort the values of a LOB column.
    Runtime Error: SAPSQL_GROUP_BY_LOB
  • Cause: An attempt was made to use a LOB column in a logical expression.
    Runtime Error: SAPSQL_BOUND_LONG_STRING
  • Cause: A pattern specified with LIKE is too long.
    Runtime Error: SAPSQL_LIKE_PATTERN_TOO_LONG and SAPSQL_LIKE_PATTERN_TOO_LONG
  • Cause: An attempt was made to select from a non-transparent table using the addition DISTINCT.
    Runtime Error: SAPSQL_ILLEGAL_DISTINCT
  • Cause: A field, whose value is to be changed with + or -, has a non-numeric type
    Runtime Error: SAPSQL_SET_PLUS_MINUS_TYPE
  • Cause: LIKE is used with the addition ESCAPE on a pooled table.
    Runtime Error: SAPSQL_ESCAPE_WITH_POOLTABLE
  • Cause: 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

  • Cause: The keyword AND is missing after the lower comparison value of BETWEEN.
    Runtime Error: SAPSQL_BETWEEN_MISSING_AND
  • Cause: The logical expression has incorrect parentheses.
    Runtime Error: SAPSQL_HAVING_PARENTHESES
  • Cause: An unknown aggregate function was found.
    Runtime Error: SAPSQL_ILLEGAL_AGGREGATE
  • Cause: The operator IS NULL is not followed by the keyword NULL.
    Runtime Error: SAPSQL_ILLEGAL_IS_NULL
  • Cause: The operator IN has incorrect parentheses.
    Runtime Error: SAPSQL_IN_ILLEGAL_LIST
  • Cause: The logical expression contains a text field literal that does not have a closing quotation mark.
    Runtime Error: SAPSQL_LIKE_QUOTES
  • Cause: The logical expression ends unexpectedly.
    Runtime Error: SAPSQL_MISSING_LOG_CONDITION
  • Cause: The Escape character is missing after the addition ESCAPE.
    Runtime Error: SAPSQL_WHERE_MISSING_ESCAPE
  • Cause: An operator is missing in the logical expression.
    Runtime Error: SAPSQL_WHERE_MISSING_OPERATOR
  • Cause: A literal or name of an ABAP variable is missing in the logical expression.
    Runtime Error: SAPSQL_WHERE_MISSING_VALUE
  • Cause: The logical expression has incorrect parentheses.
    Runtime Error: SAPSQL_WHERE_PARENTHESES
  • Cause: The logical expression contains a text field literal that does not have a closing quotation mark.
    Runtime Error: SAPSQL_WHERE_QUOTES
  • Cause: An unknown operator is used in the logical expression.
    Runtime Error: SAPSQL_WHERE_UNKNOWN_OPERATOR
  • Cause: An alias is missing.
    Runtime Error: SAPSQL_MISSING_ALIAS
  • Cause: A column from the right side of a LEFT OUTER JOIN is used in a WHERE condition.
    Runtime Error: SAPSQL_ACCESS_TO_RHS_TABLE
  • Cause: 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

UPDATE

  • Cause: An attempt was made to change a database field using an operator other than + or -.
    Runtime Error: SAPSQL_SET_NOT_PLUS_MINUS
  • Cause: An unknown operator was used in the statement SET.
    Runtime Error: SAPSQL_SET_UNKNOWN_OPERATOR
  • Cause: A literal or name of an ABAP variable is missing in the statement SET.
    Runtime Error: SAPSQL_SET_MISSING_VALUE
  • Cause: The statement SET contains a text field literal, for which there is no closing quotation mark..
    Runtime Error: SAPSQL_SET_QUOTES

CX_SY_SQL_UNSUPPORTED_FEATURE

  • Cause: A database feature is used that is not supported by the current database system.
    Runtime Error: SAPSQL_UNSUPPORTED_FEATURE


Non-Catchable Exceptions

  • Cause: Invalid call of the database interface.
    Runtime error: DBIF_RSQL_INVALID_REQUEST
  • Cause: Insufficient memory is available for the statement.
    Runtime error: DBIF_RSQL_NO_MEMORY
  • Cause: Data area passed is too short for access to the table.
    Runtime error: DBIF_RSQL_BUFFER_TOO_SHORT
  • Cause: The structure of a table is inconsistent with the dictionary.
    Runtime error: DBIF_RSQL_DDIC_INCONSISTENT
  • Cause: The sort order specified for a table is not possible.
    Runtime error: DBIF_RSQL_SORT_ORDER
  • Cause: Error when accessing the buffer of a table.
    Runtime error: DBIF_RSQL_BUFFER_ERROR
  • Cause: A table is not known or does not exist.
    Runtime error: DBIF_RSQL_TABLE_UNKNOWN
  • Cause: Internal error when accessing a table.
    Runtime error: DBIF_RSQL_INTERNAL_ERROR
  • Cause: Unexpected return code when accessing a table.
    Runtime error: DBIF_RSQL_UNEXPECTED_CODE