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

Paramètre	Reférence	Type	Long.	Valeur par déf.	Facultatif	Description
DBCON	DBCON_NAME	C	30		X	Logical name for a database connection
STATEMENT	STRING	g	0			sql statement to be parsed / scanned

Paramètre	Reférence	Type	Long.	Description
OPERATION	STMTOP	C	10	(main) sql operation (SELECT, UPDATE ...)

Paramètre	Reférence	Type	Long.	Valeur par déf.	Facultatif	Description
PCOLUMNS	TSQLPCOL	h	171			Table: columns within a parsed sql statement
PTABLES	TSQLPTABLES	h	91			Table: tables / views within a parsed sql statement

Exception	Description
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