SAP ABAP Class CL_ORA_ACTION_SQLC (ORA: SQL Command Editor)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_ORA_ACTION_CONTROLLER	ORA: Abstract Action Controller	20080125

Properties

Class	CL_ORA_ACTION_SQLC
Short Description	ORA: SQL Command Editor
Super Class	CL_ORA_ACTION_CONTROLLER	ORA: Abstract Action Controller
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	S_DBMON_ORA_COCKPIT	Database Monitor for Oracle in Cockpit Framework
Created	20071010	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ORACC	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_ORA_ACTION_SQLC has no interface implemented.

Friends

Class CL_ORA_ACTION_SQLC has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	ALV_GRID_2	Instance attribute	Public	☐	Object reference (TYPE REF TO)	CL_GUI_ALV_GRID		ALV Grid	20080125
2	CONTAINER_1	Instance attribute	Public	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER		Container for Editor Control	20080125
3	CONTAINER_2	Instance attribute	Public	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER		Container for Result ALV	20080125
4	GC_BA_ABORT	Constant	Private	☐	Type reference (TYPE)	CHAR1	3	Abort Batch Scheduling	20080125
5	GC_BA_REENTER	Constant	Private	☐	Type reference (TYPE)	CHAR1	2	Enter new parameter values	20080125
6	GC_BA_RUNJOB	Constant	Private	☐	Type reference (TYPE)	CHAR1	1	Run Job	20080125
7	GT_RESULT	Instance attribute	Private	☐	Type reference (TYPE)	TT_RESULT		Global result table	20080125
8	GWA_LAYOUT1	Instance attribute	Private	☐	Type reference (TYPE)	LVC_S_LAYO		ALV Layout	20080125
9	GWA_LAYOUT2	Instance attribute	Private	☐	Type reference (TYPE)	LVC_S_LAYO		ALV Layout	20080125
10	G_BATCH_ACTION	Instance attribute	Private	☐	Type reference (TYPE)	CHAR1		Flag: Action after batch param. Popup	20080125
11	G_BATCH_LDATE	Instance attribute	Private	☐	Type reference (TYPE)	BTCLSDATE		Latest Execution Date for a Background Job	20080125
12	G_BATCH_LTIME	Instance attribute	Private	☐	Type reference (TYPE)	BTCLSTIME		Latest Execution Time for Background Job	20080125
13	G_BATCH_PRIMM	Instance attribute	Public	☐	Type reference (TYPE)	PRIMM2		Print Time	20080125
14	G_BATCH_PRINT_CONTENT	Instance attribute	Private	☐	Type reference (TYPE)	XFELD		Print result of SQL statement (=content)	20080125
15	G_BATCH_PRINT_RT_STAT	Instance attribute	Private	☐	Type reference (TYPE)	XFELD		Print runtime analysis for SQL statement	20080125
16	G_BATCH_SDATE	Instance attribute	Private	☐	Type reference (TYPE)	BTCSDATE		Planned Start Date for Background Job	20080125
17	G_BATCH_STIME	Instance attribute	Private	☐	Type reference (TYPE)	BTCSTIME		Planned start time for background Job	20080125
18	G_BATCH_STMTID	Instance attribute	Private	☐	Type reference (TYPE)	ORA_JSEL_STMT_ID		ID for an oracle 'arbitrary join select monitor' statement	20080125
19	G_BATCH_XIMMED	Instance attribute	Private	☐	Type reference (TYPE)	XFELD		Flag: Immediate batch execution	20080125
20	G_BATCH_XSTTIM	Instance attribute	Private	☐	Type reference (TYPE)	XFELD		Flag: Batch execution at specified timestamp	20080125
21	G_CONTENT_NOT_ALLOWED	Instance attribute	Private	☐	Type reference (TYPE)	XFELD		Display of query result not allowed	20080125
22	G_DBNAVSYST	Instance attribute	Private	☐	Type reference (TYPE)	DB6NAVSYST		System Registration Table	20080125
23	G_REF_CONTAINER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER		Reference to container (for editor)	20080125
24	G_REF_EDITOR	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_TEXTEDIT		Reference to editor	20080125
25	G_REF_SERVICES	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_ORA_SRV_JSEL		Reference to instance with service methods	20080125
26	G_REMOTE_SYSTEM	Instance attribute	Private	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20080125
27	G_STMT_MARKER	Instance attribute	Private	☐	Type reference (TYPE)	CHAR40		SQL Stmt marker	20090305
28	NAV_REF	Instance attribute	Private	☐	Attribute reference (LIKE)				20100810
29	SHOW_EXPLAIN	Instance attribute	Public	☐	Type reference (TYPE)	ABAP_BOOL		True is showing of explain is allowed	20101221
30	VIEW_DATA	Instance attribute	Public	☐	Type reference (TYPE)	ORACC_ACTION_JSEL		Data displayed	20080125

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	BUILD_FIELD_CATALOG	Instance method	Public	Method	Build field catalog for output list	20080125
2	CHECK_OBJECT_TYPE	Instance method	Private	Method	Check if object is of type TABLE, SYNONYM, or VIEW	20090120
3	CLOSE_ADBC_CONNECTION	Instance method	Private	Method	Close ADBC connection (incl handling of exception)	20080125
4	CONVERT_DESCRIBE	Instance method	Private	Method	Convert DESCRIBE statement	20090120
5	CREATE_ADBC_CONNECTION	Instance method	Private	Method	Create ADBC connection for use in different DB accesses	20080125
6	CREATE_BATCH_MESSAGE	Instance method	Private	Method	Write message to result output ALV about batch processing	20080125
7	CREATE_FIELD_LIST	Instance method	Public	Method	Create the field list for the output ALV	20080125
8	CREATE_MARKER	Instance method	Public	Method	Create marker of the SQL stmt	20080125
9	CREATE_OUTPUT_ALV	Instance method	Private	Method	Create ALV list for output result	20080125
10	CREATE_SUBROUTINE_POOL	Instance method	Private	Method	Create and generate a subroutine pool containing the SQL	20080125
11	DO_AUTHORIZATION_CHECK	Instance method	Public	Method	Check access permission of tables	20080125
12	DO_MORE_AUTHORIZATION_CHECK	Instance method	Public	Method	Check access permission of tables	20100816
13	DO_SYNTAX_CHECK	Instance method	Public	Method	Perform syntax check of the SQL stmt	20080125
14	DROP_TMP_TABLE	Instance method	Public	Method	Drop temporary helper table	20080125
15	EXECUTE_QUERY	Instance method	Public	Method	Perform syntax check of the SQL stmt	20080125
16	FILL_LIST_OF_COLUMNS	Instance method	Public	Method	Fill the list of columns for the subroutine pool	20080125
17	FILL_VIEW_STRUCTURE	Instance method	Public	Method	Catch the request from the AWR Reporting Monitor	20100810
18	GET_JOB_DEFAULT_PARAMS	Instance method	Public	Method	Get default values for job parameters of current statement	20080125
19	GET_MAX_ID_COUNT	Instance method	Public	Method	Get the max ID_COUNT for given ID of table ORA_SQLC_DATA	20080125
20	GET_RESULT_TABLE	Instance method	Private	Method	Get the result of the SQL query from generated program	20080125
21	GET_SQL_STATEMENT	Instance method	Private	Method	Get SQL statement from editor	20080125
22	GET_STMT_DETAILS	Instance method	Private	Method	Get details of the stmt execution	20090305
23	GET_SYNONYM_NAME	Instance method	Private	Method	Get the name of the synonym	20090120
24	INVOKE_JSEL_METHOD	Instance method	Public	Method	Invoke old JSEL Command Editor	20081209
25	OKCODE_CREATE_JOB	Instance method	Public	Method	Create a batch job for statement execution	20080125
26	OKCODE_DELE_STMT	Instance method	Private	Method	Delete SQL statement from database	20080125
27	OKCODE_EXPLAIN_STMT	Instance method	Private	Method	Explain SQL Statement	20090305
28	OKCODE_LOAD_STMT	Instance method	Private	Method	Load SQL statement from database	20080125
29	OKCODE_PARSE	Instance method	Public	Method	Parse the edited SQL statement	20080125
30	OKCODE_PARSE_AND_EXEC	Instance method	Public	Method	Parse and Execute the edited SQL statement	20080125
31	OKCODE_SAVE_STMT	Instance method	Private	Method	Save SQL statement to database	20080125
32	SET_AND_CHECK_JOB_PARAMS	Instance method	Public	Method	Set attributes for job parameters and check them	20080125
33	SPLIT_UP_INPUT_STRING	Instance method	Public	Method	Determine the identifier for output table	20080125
34	SQL_PARSE_STMT	Instance method	Private	Method	DBMS_SQL: Parse the SQL Stmt	20090305

Events

Class CL_ORA_ACTION_SQLC has no event.

Types

Class CL_ORA_ACTION_SQLC has no local type.

Method Signatures

Method BUILD_FIELD_CATALOG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	P_FIELD_CATALOG	Call by reference	☐	Type reference (TYPE)	ORA_T_FIELD_CATALOG		ORA: Basic element of a ALV field catalog	20080125
2	Importing	P_MARKER	Call by reference	☐	Type reference (TYPE)	STRING		Marker	20100706
3	Exporting	P_RC	Call by reference	☐	Type reference (TYPE)	INT4		Return code (0=OK)	20080125
4	Importing	P_REMOTE_SYSTEM	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20080125

Method BUILD_FIELD_CATALOG on class CL_ORA_ACTION_SQLC 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	20090120
2	Importing	P_IMP_STMT	Call by reference	☐	Type reference (TYPE)	STRING		import statement	20090120

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

Method CLOSE_ADBC_CONNECTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CONNECTION	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Reference to ADBC connection that has to be closed	20080125

Method CLOSE_ADBC_CONNECTION on class CL_ORA_ACTION_SQLC 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	20090120
2	Importing	P_IMP_STMT	Call by reference	☐	Type reference (TYPE)	STRING		input string	20090120

Method CONVERT_DESCRIBE on class CL_ORA_ACTION_SQLC has no exception.

Method CREATE_ADBC_CONNECTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_CONNECTION	Value transfer	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Reference to created connection	20080125

Method CREATE_ADBC_CONNECTION on class CL_ORA_ACTION_SQLC has no exception.

Method CREATE_BATCH_MESSAGE Signature

Method CREATE_BATCH_MESSAGE on class CL_ORA_ACTION_SQLC has no parameter.
Method CREATE_BATCH_MESSAGE on class CL_ORA_ACTION_SQLC has no exception.

Method CREATE_FIELD_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_MARKER	Call by reference	☐	Type reference (TYPE)	STRING		Marker	20100706
2	Exporting	P_RC	Call by reference	☐	Type reference (TYPE)	I		Return code	20080125
3	Importing	P_REMOTE_SYSTEM	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20080125
4	Importing	P_SQL_STMT_TEXT	Call by reference	☐	Type reference (TYPE)	STRING		SQL stmt text	20080125

Method CREATE_FIELD_LIST on class CL_ORA_ACTION_SQLC has no exception.

Method CREATE_MARKER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	P_VMARKER	Call by reference	☐	Type reference (TYPE)	STRING		Marker	20080125

Method CREATE_MARKER on class CL_ORA_ACTION_SQLC has no exception.

Method CREATE_OUTPUT_ALV Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_FIELD_CATALOG	Call by reference	☐	Object reference (TYPE REF TO)	ORA_T_FIELD_CATALOG		ORA: Table type basic elements of ALV field catalog	20080125
2	Exporting	P_RC	Call by reference	☐	Type reference (TYPE)	INT4		Return code (0=OK)	20080125

Method CREATE_OUTPUT_ALV on class CL_ORA_ACTION_SQLC has no exception.

Method CREATE_SUBROUTINE_POOL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_RC	Call by reference	☐	Type reference (TYPE)	I		<> 0 if error occured	20080125
2	Exporting	E_SQL_REPORT	Call by reference	☐	Type reference (TYPE)	PROGNAME		ABAP Program Name, generated report	20080125
3	Importing	IT_COLUMNS	Call by reference	☐	Type reference (TYPE)	TSQLPCOL		list of columns to read in the statement	20080125
4	Importing	IT_TABLES	Call by reference	☐	Type reference (TYPE)	TSQLPTABLES		list of tables used in the statement	20080125
5	Importing	I_SQL_STATEMENT	Call by reference	☐	Type reference (TYPE)	STRING		SQL statement	20080125
6	Importing	P_IDENTIFIER	Call by reference	☐	Type reference (TYPE)	STRING		Identifier of table ORA_SQLC_DATA	20080125
7	Importing	P_MAX_COUNT	Call by reference	☐	Type reference (TYPE)	I		Max ID_COUNT for given ID of table ORA_SQLC_DATA	20080125

Method CREATE_SUBROUTINE_POOL on class CL_ORA_ACTION_SQLC has no exception.

Method DO_AUTHORIZATION_CHECK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_REMOTE_SYSTEM	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20080125
2	Exporting	P_VCOUNT	Call by reference	☐	Type reference (TYPE)	INT4		Authorization (0=Authorization ok)	20080125
3	Importing	P_VMARKER	Call by reference	☐	Type reference (TYPE)	STRING		Marker	20080125

Method DO_AUTHORIZATION_CHECK on class CL_ORA_ACTION_SQLC has no exception.

Method DO_MORE_AUTHORIZATION_CHECK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	P_AUTH_DISP	Call by reference	☐	Type reference (TYPE)	INT4		Authorization (0=Authorization ok)	20100816
2	Importing	P_REMOTE_SYSTEM	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20100816
3	Importing	P_VMARKER	Call by reference	☐	Type reference (TYPE)	STRING		Marker of SQL stmt	20100816

Method DO_MORE_AUTHORIZATION_CHECK on class CL_ORA_ACTION_SQLC has no exception.

Method DO_SYNTAX_CHECK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	P_RC	Call by reference	☐	Type reference (TYPE)	I		Return code	20080125
2	Importing	P_REMOTE_SYSTEM	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20080125
3	Importing	P_SQL_STMT_TEXT	Call by reference	☐	Type reference (TYPE)	STRING		SQL stmt text	20080125
4	Importing	P_VMARKER	Call by reference	☐	Type reference (TYPE)	STRING		Marker	20080125

Method DO_SYNTAX_CHECK on class CL_ORA_ACTION_SQLC has no exception.

Method DROP_TMP_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	P_MARKER	Call by reference	☐	Type reference (TYPE)	STRING		Marker	20100706
2	Importing	P_REMOTE_SYSTEM	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20080125

Method DROP_TMP_TABLE on class CL_ORA_ACTION_SQLC has no exception.

Method EXECUTE_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	P_RC	Call by reference	☐	Type reference (TYPE)	I		Return code	20080125
2	Importing	P_REMOTE_SYSTEM	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20080125
3	Importing	P_SQL_STMT_TEXT	Call by reference	☐	Type reference (TYPE)	STRING		SQL stmt text	20080125
4	Importing	P_VMARKER	Call by reference	☐	Type reference (TYPE)	STRING		Marker	20080125

Method EXECUTE_QUERY on class CL_ORA_ACTION_SQLC has no exception.

Method FILL_LIST_OF_COLUMNS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	P_COLUMNS	Call by reference	☐	Type reference (TYPE)	TSQLPCOL		Table: columns within a parsed sql statement	20080125
2	Importing	P_FIELD_CATALOG	Call by reference	☐	Type reference (TYPE)	ORA_T_FIELD_CATALOG		ORA: Table type basic elements of ALV field catalog	20080125
3	Importing	P_MARKER	Call by reference	☐	Type reference (TYPE)	STRING		Marker	20100706

Method FILL_LIST_OF_COLUMNS on class CL_ORA_ACTION_SQLC has no exception.

Method FILL_VIEW_STRUCTURE Signature

Method FILL_VIEW_STRUCTURE on class CL_ORA_ACTION_SQLC has no parameter.
Method FILL_VIEW_STRUCTURE on class CL_ORA_ACTION_SQLC has no exception.

Method GET_JOB_DEFAULT_PARAMS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_BATCH_PRINT_CONTENT	Call by reference	☐	Type reference (TYPE)	XFELD		Print result of SQL statement (=content)	20080125
2	Exporting	E_BATCH_PRINT_RT_STAT	Call by reference	☐	Type reference (TYPE)	XFELD		Print runtime analysis for SQL statement	20080125
3	Exporting	E_BATCH_STMTID	Call by reference	☐	Type reference (TYPE)	ORA_JSEL_STMT_ID		ID for an oracle 'arbitrary join select monitor' statement	20080125

Method GET_JOB_DEFAULT_PARAMS on class CL_ORA_ACTION_SQLC 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	20080125
2	Returning	P_MAX_COUNT	Value transfer	☐	Type reference (TYPE)	I		Max ID_COUNT for given ID of table ORA_SQLC_DATA	20080125

Method GET_MAX_ID_COUNT on class CL_ORA_ACTION_SQLC has no exception.

Method GET_RESULT_TABLE Signature

Method GET_RESULT_TABLE on class CL_ORA_ACTION_SQLC has no parameter.
Method GET_RESULT_TABLE on class CL_ORA_ACTION_SQLC has no exception.

Method GET_SQL_STATEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_SQL_STATEMENT	Call by reference	☐	Type reference (TYPE)	ORA_JSEL_TEXTTAB		Text table for ORA arbitrary join monitor	20080125
2	Exporting	E_SQL_STATEMENT	Call by reference	☐	Type reference (TYPE)	STRING		SQL statement as string	20080125

Method GET_SQL_STATEMENT on class CL_ORA_ACTION_SQLC has no exception.

Method GET_STMT_DETAILS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	P_ORA_PAR	Call by reference	☐	Type reference (TYPE)	ORAEXPLPAR		Parameter for Explain from v$sql_plan	20090305
2	Exporting	P_RC	Call by reference	☐	Type reference (TYPE)	I		return code	20090305

Method GET_STMT_DETAILS on class CL_ORA_ACTION_SQLC 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	20090120
2	Exporting	P_EXP_OWNER	Call by reference	☐	Type reference (TYPE)	STRING		export table owner	20090120
3	Importing	P_IMP_NAME	Call by reference	☐	Type reference (TYPE)	STRING		input name	20090120

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

Method INVOKE_JSEL_METHOD Signature

Method INVOKE_JSEL_METHOD on class CL_ORA_ACTION_SQLC has no parameter.
Method INVOKE_JSEL_METHOD on class CL_ORA_ACTION_SQLC has no exception.

Method OKCODE_CREATE_JOB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SQL_STATEMENT	Call by reference	☑	Type reference (TYPE)	STRING_TABLE		SQL statement	20080125

Method OKCODE_CREATE_JOB on class CL_ORA_ACTION_SQLC has no exception.

Method OKCODE_DELE_STMT Signature

Method OKCODE_DELE_STMT on class CL_ORA_ACTION_SQLC has no parameter.
Method OKCODE_DELE_STMT on class CL_ORA_ACTION_SQLC has no exception.

Method OKCODE_EXPLAIN_STMT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SQL_STATEMENT	Call by reference	☑	Type reference (TYPE)	STRING			20090305

Method OKCODE_EXPLAIN_STMT on class CL_ORA_ACTION_SQLC has no exception.

Method OKCODE_LOAD_STMT Signature

Method OKCODE_LOAD_STMT on class CL_ORA_ACTION_SQLC has no parameter.
Method OKCODE_LOAD_STMT on class CL_ORA_ACTION_SQLC has no exception.

Method OKCODE_PARSE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_MSG_TXT	Call by reference	☐	Type reference (TYPE)	STRING			20080125
2	Exporting	E_RC	Call by reference	☐	Type reference (TYPE)	I			20080125
3	Importing	I_SQL_STATEMENT	Call by reference	☑	Type reference (TYPE)	STRING			20080125

Method OKCODE_PARSE on class CL_ORA_ACTION_SQLC has no exception.

Method OKCODE_PARSE_AND_EXEC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_MSG_TXT	Call by reference	☐	Type reference (TYPE)	STRING			20080125
2	Exporting	E_RC	Call by reference	☐	Type reference (TYPE)	I			20080125
3	Importing	I_SQL_STATEMENT	Call by reference	☑	Type reference (TYPE)	STRING			20080125

Method OKCODE_PARSE_AND_EXEC on class CL_ORA_ACTION_SQLC has no exception.

Method OKCODE_SAVE_STMT Signature

Method OKCODE_SAVE_STMT on class CL_ORA_ACTION_SQLC has no parameter.
Method OKCODE_SAVE_STMT on class CL_ORA_ACTION_SQLC has no exception.

Method SET_AND_CHECK_JOB_PARAMS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_BATCH_LDATE	Call by reference	☐	Type reference (TYPE)	BTCLSDATE		Latest Execution Date for a Background Job	20080125
2	Importing	I_BATCH_LTIME	Call by reference	☐	Type reference (TYPE)	BTCLSTIME		Latest Execution Time for Background Job	20080125
3	Importing	I_BATCH_PRIMM	Call by reference	☐	Type reference (TYPE)	PRIMM2		Print time	20080125
4	Importing	I_BATCH_PRINT_CONTENT	Call by reference	☐	Type reference (TYPE)	XFELD		Print result of SQL statement (=content)	20080125
5	Importing	I_BATCH_PRINT_RT_STAT	Call by reference	☐	Type reference (TYPE)	XFELD		Print runtime analysis for SQL statement	20080125
6	Importing	I_BATCH_SDATE	Call by reference	☐	Type reference (TYPE)	BTCSDATE		Planned Start Date for Background Job	20080125
7	Importing	I_BATCH_STIME	Call by reference	☐	Type reference (TYPE)	BTCSTIME		Planned start time for background Job	20080125
8	Importing	I_BATCH_STMTID	Call by reference	☐	Type reference (TYPE)	ORA_JSEL_STMT_ID		ID for an oracle 'arbitrary join select monitor' statement	20080125
9	Importing	I_BATCH_XIMMED	Call by reference	☐	Type reference (TYPE)	XFELD		Flag: Immediate batch execution	20080125
10	Importing	I_BATCH_XSTTIM	Call by reference	☐	Type reference (TYPE)	XFELD		Flag: Batch execution at specified timestamp	20080125

Method SET_AND_CHECK_JOB_PARAMS on class CL_ORA_ACTION_SQLC has no exception.

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	20080125
2	Changing	P_TAB_IDENTIFIER	Call by reference	☐	Type reference (TYPE)	STRING		Identifier for output table	20080125

Method SPLIT_UP_INPUT_STRING on class CL_ORA_ACTION_SQLC 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)	ORA_JSEL_TEXTTAB		Text table for ORA arbitrary join monitor	20090305

Method SQL_PARSE_STMT on class CL_ORA_ACTION_SQLC has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	703