SAP ABAP Function Module SCAN_ORA_SELECT_STATEMENT (scan oracle select statement for columns and tables)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷
STUO (Package) ORACLE Database Monitor
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors⤷
STUO (Package) ORACLE Database Monitor
Basic Data
| Function Module | SCAN_ORA_SELECT_STATEMENT | scan oracle select statement for columns and tables |
| Function Group | STD9 | Oracle Monitoring (New features) |
| Program Name | SAPLSTD9 | Update Statistics for Certain Index |
| INCLUDE Name | LSTD9U05 |
Parameters
| Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
|---|---|---|---|---|---|---|---|
 Changing |
PTABLES | TYPE | TSQLPTABLES | Table: tables / views within a parsed sql statement | |||
| Changing |
PCOLUMNS | TYPE | TSQLPCOL | Table: columns within a parsed sql statement | |||
 Exporting |
OPERATION | TYPE | STMTOP | (main) sql operation (SELECT, UPDATE ...) | |||
 Importing |
STATEMENT | TYPE | STRING | sql statement to be parsed / scanned | |||
| Importing |
DBCON | TYPE | DBCON_NAME | Logical name for a database connection | |||
 Exception |
NO_STATEMENT | TYPE | statement is empty | ||||
| Exception |
NO_OPERATION_FOUND | TYPE | no operation found in the statement | ||||
| Exception |
INVALID_SQL_OPERATION | TYPE | invalid sql operation found in the statement | ||||
| Exception |
ERROR_IN_HINT | TYPE | error in parsing hint | ||||
| Exception |
ERROR_IN_PARSING_SELECT_LIST | TYPE | error in parsing the select list | ||||
| Exception |
ERROR_IN_TABLE_REFERENCES | TYPE | error in parsing the table references | ||||
| Exception |
COLUMNS_NOT_MATCHING_WITH_TABS | TYPE | columns could not be matched to tables | ||||
| Exception |
ERROR_REDUCING_DISTINCT | TYPE | error while reducing DISTINCT / UNIQUE / ALL | ||||
| Exception |
ERROR_IN_SET_OPERATOR | TYPE | error in parsing UNION / INTERSECT / MINUS | ||||
| Exception |
NO_FROM_FOUND | TYPE | no from with table references found | ||||
Processing Type
| Normal Function Module | |
 Remote-Enabled Module |
BaseXML supported |
| Update Module | Start immediately |
| Immediate Start, No Restart | |
| Start Delayed | |
| Coll.run | |
| JAVA Module Callable from ABAP | |
| Remote-Enabled JAVA Module | |
| Module Callable from JAVA |
History
| Last changed by/on | SAP | 20041005 |
| SAP Release Created in | 640 |
