SAP ABAP Class CL_ORA_SQL_EXECUTOR (ORA Implementation for SQL Execution)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_ORA_COCKPIT (Package) DBACockpit: Oracle Monitors

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_DBA_SQL_EXECUTOR	DBA Cockpit SQL Executor - Dynamic (ADBC)	20110216

Properties

Class	CL_ORA_SQL_EXECUTOR
Short Description	ORA Implementation for SQL Execution
Super Class	CL_DBA_SQL_EXECUTOR	DBA Cockpit SQL Executor - Dynamic (ADBC)
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	S_ORA_COCKPIT	DBACockpit: Oracle Monitors
Created	20110208	SAP
Last change	20140121	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_ORA_SQL_EXECUTOR has no forward declaration.

Interfaces

Class CL_ORA_SQL_EXECUTOR has no interface implemented.

Friends

#	Friend	Modeled only	Created on	Description
1	CL_DBA_SQL_EXECUTOR	☐	20110216	DBA Cockpit SQL Executor - Dynamic (ADBC)

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	SQL_EXECUTOR	Static Attribute	Private	☐	Object reference (TYPE REF TO)	CL_ORA_SQL_EXECUTOR		for ORA	20110216

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CHECK_ACCESS_AUTHORITY	Instance method	Public	Method	Check if user is allowed to access all specified tables	20110222
2	CHECK_OBJECT_TYPE	Instance method	Private	Method	Check if object is of type TABLE, SYNONYM, or VIEW	20110216
3	CONSTRUCTOR	Instance method	Public	Constructor		20110216
4	CONVERT_DESCRIBE	Instance method	Private	Method	Convert DESCRIBE statement	20110216
5	CREATE_MARKER	Static method	Public	Method	Create marker of the SQL stmt	20110222
6	DIVIDE_SQL_STMT	Instance method	Public	Method	Divide the SQL stmt string into parts	20110907
7	GET_MAX_ID_COUNT	Instance method	Public	Method	Get the max ID_COUNT for given ID of table ORA_SQLC_DATA	20110421
8	GET_SYNONYM_NAME	Instance method	Private	Method	Get the name of the synonym	20110216
9	GET_TABLES_IN_SELECT	Instance method	Private	Method	Get names of tables which are part of the select stmt	20110222
10	GET_TIMESTAMP	Instance method	Private	Method	Get timestamp from the database level	20110421
11	SPLIT_UP_INPUT_STRING	Instance method	Public	Method	Determine the identifier for output table	20110421
12	SQL_PARSE_STMT	Instance method	Public	Method	DBMS_SQL: Parse the SQL Stmt	20110222
13	WRITE_OUTPUT_TABLE	Instance method	Public	Method	Write result to tables ORA_SQLC_HEAD and ORA_SQLC_DATA	20110421
14	WRITE_TO_DATA	Instance method	Private	Method	Write data to ORA_SQLC_DATA	20110421
15	WRITE_TO_HEAD	Instance method	Private	Method	Write data to ORA_SQLC_HEAD	20110421

Events

Class CL_ORA_SQL_EXECUTOR has no event.

Types

Class CL_ORA_SQL_EXECUTOR has no local type.

Method Signatures

Method CHECK_ACCESS_AUTHORITY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_REMSYS	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20110222
2	Importing	P_STMT	Call by reference	☐	Type reference (TYPE)	STRING		SQL Statement	20110222
3	Returning	R_CHECK_FLAG	Value transfer	☐	Type reference (TYPE)	I		Return value for authorization	20110222

Method CHECK_ACCESS_AUTHORITY on class CL_ORA_SQL_EXECUTOR has no exception.

Method CHECK_OBJECT_TYPE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	P_EXP_OBJECT_TYPE	Value transfer	☐	Type reference (TYPE)	STRING		object type	20110216
2	Importing	P_IMP_STMT	Call by reference	☐	Type reference (TYPE)	STRING		import statement	20110216
3	Importing	P_REMSYS	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20110216

#	Exception	Resumable	Description	Created on
1	CX_DBA_DATABASE	☐	DBA Cockpit: DB Exceptions	20110216

Method CONSTRUCTOR Signature

Method CONSTRUCTOR on class CL_ORA_SQL_EXECUTOR has no parameter.
Method CONSTRUCTOR on class CL_ORA_SQL_EXECUTOR has no exception.

Method CONVERT_DESCRIBE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	P_EXP_STMT	Call by reference	☐	Type reference (TYPE)	STRING		export string	20110216
2	Importing	P_IMP_STMT	Call by reference	☐	Type reference (TYPE)	STRING		input string	20110216
3	Importing	P_REMSYS	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20110216

Method CONVERT_DESCRIBE on class CL_ORA_SQL_EXECUTOR has no exception.

Method CREATE_MARKER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RET_MARKER	Value transfer	☐	Type reference (TYPE)	STRING		Marker for SQL Stmt	20110222

Method CREATE_MARKER on class CL_ORA_SQL_EXECUTOR has no exception.

Method DIVIDE_SQL_STMT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EX_LEN1	Call by reference	☐	Type reference (TYPE)	I		Length of part 1	20110907
2	Exporting	EX_LEN2	Call by reference	☐	Type reference (TYPE)	I		Length of part 2	20110907
3	Exporting	EX_LEN3	Call by reference	☐	Type reference (TYPE)	I		Length of part 3	20110907
4	Exporting	EX_LEN4	Call by reference	☐	Type reference (TYPE)	I		Length of part 4	20110907
5	Exporting	EX_LEN5	Call by reference	☐	Type reference (TYPE)	I		Length of part 5	20111027
6	Exporting	EX_LEN6	Call by reference	☐	Type reference (TYPE)	I		Length of part 6	20111027
7	Exporting	EX_LEN7	Call by reference	☐	Type reference (TYPE)	I		Length of part 7	20111027
8	Exporting	EX_LEN8	Call by reference	☐	Type reference (TYPE)	I		Length of part 8	20111027
9	Exporting	EX_PART1	Call by reference	☐	Type reference (TYPE)	STRING		Part 1 of SQL Stmt	20110907
10	Exporting	EX_PART2	Call by reference	☐	Type reference (TYPE)	STRING		Part 2 of SQL Stmt	20110907
11	Exporting	EX_PART3	Call by reference	☐	Type reference (TYPE)	STRING		Part 3 of SQL Stmt	20110907
12	Exporting	EX_PART4	Call by reference	☐	Type reference (TYPE)	STRING		Part 4 of SQL Stmt	20110907
13	Exporting	EX_PART5	Call by reference	☐	Type reference (TYPE)	STRING		Part 5 of SQL Stmt	20111027
14	Exporting	EX_PART6	Call by reference	☐	Type reference (TYPE)	STRING		Part 6 of SQL Stmt	20111027
15	Exporting	EX_PART7	Call by reference	☐	Type reference (TYPE)	STRING		Part 7 of SQL Stmt	20111027
16	Exporting	EX_PART8	Call by reference	☐	Type reference (TYPE)	STRING		Part 8 of SQL Stmt	20111027
17	Exporting	EX_RET_CODE	Call by reference	☐	Type reference (TYPE)	I		Return code	20110907
18	Importing	I_STMT	Call by reference	☐	Type reference (TYPE)	STRING		SQL Stmt	20110907

Method DIVIDE_SQL_STMT on class CL_ORA_SQL_EXECUTOR has no exception.

Method GET_MAX_ID_COUNT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_IDENTIFIER	Call by reference	☐	Type reference (TYPE)	STRING		Identifier of table ORA_SQLC_DATA	20110421
2	Returning	P_MAX_COUNT	Value transfer	☐	Type reference (TYPE)	I		Max ID_COUNT for given ID of table ORA_SQLC_DATA	20110421

Method GET_MAX_ID_COUNT on class CL_ORA_SQL_EXECUTOR has no exception.

Method GET_SYNONYM_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	P_EXP_NAME	Call by reference	☐	Type reference (TYPE)	STRING		export table name	20110216
2	Exporting	P_EXP_OWNER	Call by reference	☐	Type reference (TYPE)	STRING		export table owner	20110216
3	Importing	P_IMP_NAME	Call by reference	☐	Type reference (TYPE)	STRING		input name	20110216
4	Importing	P_REMSYS	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Description of Database Connections	20110216

#	Exception	Resumable	Description	Created on
1	CX_DBA_DATABASE	☐	DBA Cockpit: DB Exceptions	20110216

Method GET_TABLES_IN_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	P_CHECK_FLAG	Value transfer	☐	Type reference (TYPE)	I		Return value for authorization	20110222
2	Importing	P_REMSYS	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20110222
3	Importing	P_VMARKER	Call by reference	☐	Type reference (TYPE)	STRING		Marker of SQL stmt	20110222

Method GET_TABLES_IN_SELECT on class CL_ORA_SQL_EXECUTOR has no exception.

Method GET_TIMESTAMP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_REMSYS	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20110421
2	Exporting	P_TIMESTAMP	Call by reference	☐	Type reference (TYPE)	STRING		Timestamp	20110421

#	Exception	Resumable	Description	Created on
1	CX_DBA_DATABASE	☐	DBA Cockpit: DB Exceptions	20110421

Method SPLIT_UP_INPUT_STRING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	P_SQL_STMT_TEXT	Call by reference	☐	Type reference (TYPE)	STRING		Input: full text from Editor/Output: SQL Stmt text	20110421
2	Changing	P_TAB_IDENTIFIER	Call by reference	☐	Type reference (TYPE)	STRING		Identifier for output table	20110421

Method SPLIT_UP_INPUT_STRING on class CL_ORA_SQL_EXECUTOR has no exception.

Method SQL_PARSE_STMT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PT_SQL_STATEMENT	Call by reference	☐	Type reference (TYPE)	STRING		Text table for ORA arbitrary join monitor	20110222
2	Importing	P_REMSYS	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20110222
3	Exporting	P_RET_CODE	Call by reference	☐	Type reference (TYPE)	I		Return code	20110907
4	Importing	P_VMARKER	Call by reference	☐	Type reference (TYPE)	STRING		Marker of SQL Stmt	20110222

Method SQL_PARSE_STMT on class CL_ORA_SQL_EXECUTOR has no exception.

Method WRITE_OUTPUT_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_DATA	Call by reference	☐	Type reference (TYPE)	DATA		Result data	20110421
2	Importing	P_FIELDCAT	Call by reference	☐	Object reference (TYPE REF TO)	CL_ABAP_STRUCTDESCR		Runtime Type Services	20110421
3	Importing	P_ID_COUNT	Call by reference	☐	Type reference (TYPE)	I		max. ID count in table ORA_SQLC_DATA	20110421
4	Importing	P_REMSYS	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20110421
5	Importing	P_TAB_IDENTIFIER	Call by reference	☐	Type reference (TYPE)	STRING		identifier for ORA_SQLC_HEAD/DATA	20110421

Method WRITE_OUTPUT_TABLE on class CL_ORA_SQL_EXECUTOR has no exception.

Method WRITE_TO_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_DATA	Call by reference	☐	Type reference (TYPE)	DATA			20110421
2	Importing	P_FIELDCAT	Call by reference	☐	Object reference (TYPE REF TO)	CL_ABAP_STRUCTDESCR		Runtime Type Services	20110421
3	Importing	P_WA_DATA	Call by reference	☐	Type reference (TYPE)	ORA_SQLC_DATA		ORA: SQL Command Editor Data Table	20110421

Method WRITE_TO_DATA on class CL_ORA_SQL_EXECUTOR has no exception.

Method WRITE_TO_HEAD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_WA_HEAD	Call by reference	☐	Type reference (TYPE)	ORA_SQLC_S_HEAD		ORA_SQLC_HEAD-STRUCTURE	20110421

Method WRITE_TO_HEAD on class CL_ORA_SQL_EXECUTOR has no exception.

History

Last changed by/on	SAP	20140121
SAP Release Created in	731