SAP ABAP Class CL_SQL_METADATA_ORA (Implements CL_SQL_METADATA for Oracle)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DBI (Application Component) DB-Independent Database Interface
     ⤷ SDB_ADBC (Package) ABAP Database Call Interface (Dynamic SQL)

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_SQL_METADATA	Method to Describe DB Objects	20010521

Properties

Class	CL_SQL_METADATA_ORA
Short Description	Implements CL_SQL_METADATA for Oracle
Super Class	CL_SQL_METADATA	Method to Describe DB Objects
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	SDB_ADBC	ABAP Database Call Interface (Dynamic SQL)
Created	20010521	SAP
Last change	20110908	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

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

Interfaces

Class CL_SQL_METADATA_ORA has no interface implemented.

Friends

Class CL_SQL_METADATA_ORA has no friend class.

Attributes

Class CL_SQL_METADATA_ORA has no attribute.

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_CATALOG_QUERY	Instance method	Private	Method		20021126
2	GET_CHARACTER_SET	Instance method	Private	Method	Get character set from v$nls_parameters	20081005
3	GET_SYSTEM_TYPE	Instance method	Private	Method		20090504
4	HAS_CHAR_LENGTH	Instance method	Private	Method	CHAR_LENGTH column contained in ALL_TAB_COLUMNS?	20071017
5	MAP_DB_TO_DDIC_TYPE	Static method	Private	Method	Mapping of Oracle Type to Appropriate DDIC Type	20010521

Events

Class CL_SQL_METADATA_ORA has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	ORACHARSET	Private	See coding			20081005	ORACHARSET(64) TYPE c

Method Signatures

Method ADD_CATALOG_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	COLUMN_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME		Name einer Tabellenspalte	20021126
2	Importing	OWNER_COND	Call by reference	☐	Type reference (TYPE)	STRING		Bedingung auf der OWNER Spalte	20021126
3	Changing	STMT	Call by reference	☐	Type reference (TYPE)	STRING		SQL Statement	20021126
4	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME		Name einer Oracle Katalog-Tabelle	20021126
5	Importing	TABLE_RGTAB	Call by reference	☐	Type reference (TYPE)	ADBC_NAME_RGTAB		Range-Tabelle zur Eingrenzung von Tabellen	20021126
6	Importing	TABLE_TYPE	Call by reference	☐	Type reference (TYPE)	ADBC_TABLE_TYPE		Tabellentyp	20021126

Method ADD_CATALOG_QUERY on class CL_SQL_METADATA_ORA has no exception.

Method GET_CHARACTER_SET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CHARSET	Value transfer	☐	Type reference (TYPE)	ORACHARSET			20081005

Method GET_CHARACTER_SET on class CL_SQL_METADATA_ORA has no exception.

Method GET_SYSTEM_TYPE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	IS_SAP_SYSTEM	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090504
2	Importing	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20090504

Method GET_SYSTEM_TYPE on class CL_SQL_METADATA_ORA has no exception.

Method HAS_CHAR_LENGTH Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	FLAG		allgemeines flag	20071017

Method HAS_CHAR_LENGTH on class CL_SQL_METADATA_ORA has no exception.

Method MAP_DB_TO_DDIC_TYPE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CHARSET	Call by reference	☐	Type reference (TYPE)	ORACHARSET			20081005
2	Importing	CHAR_USED	Call by reference	☐	Type reference (TYPE)	FLAG		allgemeines flag	20090504
3	Changing	COLUMN_DESCR	Call by reference	☐	Type reference (TYPE)	ADBC_TABCOL_DESCR			20010607
4	Importing	IS_SAP_SYSTEM	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20090504

Method MAP_DB_TO_DDIC_TYPE on class CL_SQL_METADATA_ORA has no exception.

History

Last changed by/on	SAP	20110908
SAP Release Created in	620