SAP Function SCAN_ORA_SELECT_STATEMENT - scan oracle select statement for columns and tables

Parameter Reference Type Length Default Optional Text
DBCON DBCON_NAME C 30 X Logical name for a database connection
STATEMENT STRING g 0 sql statement to be parsed / scanned

Parameter Reference Type Length Text
OPERATION STMTOP C 10 (main) sql operation (SELECT, UPDATE ...)

Parameter Reference Type Length Default Optional Text
PCOLUMNS TSQLPCOL h 171 Table: columns within a parsed sql statement
PTABLES TSQLPTABLES h 91 Table: tables / views within a parsed sql statement

Exception Text
COLUMNS_NOT_MATCHING_WITH_TABS columns could not be matched to tables
ERROR_IN_HINT error in parsing hint
ERROR_IN_PARSING_SELECT_LIST error in parsing the select list
ERROR_IN_SET_OPERATOR error in parsing UNION / INTERSECT / MINUS
ERROR_IN_TABLE_REFERENCES error in parsing the table references
ERROR_REDUCING_DISTINCT error while reducing DISTINCT / UNIQUE / ALL
INVALID_SQL_OPERATION invalid sql operation found in the statement
NO_FROM_FOUND no from with table references found
NO_OPERATION_FOUND no operation found in the statement
NO_STATEMENT statement is empty