Oracle | DBMS_SQLTCB

Oracle DBMS_SQLTCB_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Believed related to incident reporting

AUTHID CURRENT_USER

Dependencies

ALL_TABLES	DBMS_SMB	KU$_STATUS
ANYDATA	DBMS_SQL	OL$
DBA_CLUSTERS	DBMS_SQLDIAG	PLITBLM
DBA_DIRECTORIES	DBMS_SQLDIAG_INTERNAL	PRVT_REPORT_TAGS
DBA_HIST_SNAPSHOT	DBMS_SQLTCB_LIB	SQL$TEXT
DBA_HIST_SQLSTAT	DBMS_SQLTUNE	SQLSET_ROW
DBA_INDEXES	DBMS_SQLTUNE_INTERNAL	SQL_BINDS
DBA_SEGMENTS	DBMS_STANDARD	USER_USERS
DBA_SQLSET_STATEMENTS	DBMS_STATS	UTL_FILE
DBA_TABLES	DBMS_STATS_INTERNAL	UTL_RAW
DBMS_ASSERT	DBMS_SYS_ERROR	V_$DATABASE
DBMS_DATAPUMP	DBMS_XPLAN	V_$DIAG_INFO
DBMS_LOB	DBMS_XPLAN_TYPE_TABLE	V_$INSTANCE
DBMS_OUTLN_LIB	DUAL	V_$PARAMETER
DBMS_OUTPUT	KU$_JOBDESC	V_$PROCESS
DBMS_REPORT	KU$_JOBSTATUS	V_$SESSION
DBMS_SESSION	KU$_LOGENTRY	XMLSEQUENCE
DBMS_SHARED_POOL	KU$_LOGLINE1010	XMLTYPE

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvtsqld.plb

Subprograms

FIXQ	I_EXPLAIN_SQL_TESTCASE	I_SET_TRACING
I_CAPTURE_BIND_LIST	I_GENERATE_SQL_TESTCASE	I_TCB_CHECK_REPLAY_PARAMETERS
I_CLOB_LOAD	I_GET_FILE_NAME	I_TCB_HAS_DYN_STS
I_COMPRESS_TESTCASE	I_IMPORT_SQL_TESTCASE	I_TCB_INIT_SCRIPT_PREFIX
I_CONVERT_FROM_BOOLEAN	I_REPLAY_BIND_LIST	I_VALIDATE_INCIDENTID
I_CONVERT_TO_BOOLEAN	I_REPLAY_SQL_TESTCASE	UPCASE

FIXQ (new 21c)

Undocumented dbms_sqltcb_internal.fixq(str IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_sqltcb_internal.fixq(str IN VARCHAR2)

      FROM dual;

I_CAPTURE_BIND_LIST

Undocumented dbms_sqltcb_internal.i_capture_bind_list( directory IN VARCHAR2, scriptfile IN VARCHAR2, sql_stmt IN sys.sqlset_row);

TBD

I_CLOB_LOAD

Undocumented dbms_sqltcb_internal.i_clob_load( directory IN VARCHAR2, fname IN VARCHAR2, res IN OUT CLOB);

TBD

I_COMPRESS_TESTCASE

Undocumented dbms_sqltcb_internal.i_compress_testcase( testcase_name IN VARCHAR2, directory IN VARCHAR2) RETURN BOOLEAN;

TBD

I_CONVERT_FROM_BOOLEAN

Returns a string corresponding with the input Boolean value dbms_sqltcb_internal.i_convert_from_boolean(bool IN BOOLEAN) RETURN VARCHAR2;

DECLARE

       inVal BOOLEAN := FALSE;

      BEGIN

        dbms_output.put_line(dbms_sqltcb_internal.i_convert_from_boolean(inVal));

      END;

      /

      FALSE

      

      PL/SQL procedure successfully completed.

I_CONVERT_TO_BOOLEAN

Returns a boolean corresponding with the input TRUE or FALSE string dbms_sqltcb_internal.convert_to_boolean(bool IN VARCHAR2) RETURN BOOLEAN;

DECLARE

       inVal VARCHAR2(5) := 'FALSE';

      BEGIN

        IF dbms_sqltcb_internal.i_convert_to_boolean(inVal) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

I_EXPLAIN_SQL_TESTCASE

Undocumented dbms_sqltcb_internal.i_explain_sql_testcase( sqltestcase IN CLOB, sql_stmt IN sys.sqlset_row);

TBD

I_GENERATE_SQL_TESTCASE

Undocumented dbms_sqltcb_internal.i_generate_sql_testcase( directory IN VARCHAR2, sql_stmt IN sys.sqlset_row, incidentid IN VARCHAR2, user_name IN VARCHAR2, exec_user_id IN NUMBER, task_name IN VARCHAR2, exportenvironment IN BOOLEAN, exportmetadata IN BOOLEAN, exportdata IN BOOLEAN, exportpkgbody IN BOOLEAN, samplingpercent IN NUMBER, timelimit IN NUMBER, testcase_name IN VARCHAR2, testcasemetadata IN OUT CLOB, preserveschemamapping IN BOOLEAN, version IN VARCHAR2, ctrloptions IN VARCHAR2, problem_type IN NUMBER);

TBD

I_GET_FILE_NAME

Undocumented dbms_sqltcb_internal.i_get_file_name( sqltestcase IN CLOB, stgtabeixst OUT BOOLEAN, ftype IN VARCHAR2) RETURN VARCHAR2;

TBD

I_IMPORT_SQL_TESTCASE

Undocumented dbms_sqltcb_internal.i_import_sql_testcase( directory IN VARCHAR2, sqltestcase IN CLOB, importenvironment IN BOOLEAN, importmetadata IN BOOLEAN, importdata IN BOOLEAN, importpkgbody IN BOOLEAN, importdiagnosis IN BOOLEAN, ignorestorage IN BOOLEAN, ctrloptions IN VARCHAR2, preserveschemamapping IN BOOLEAN);

TBD

I_REPLAY_BIND_LIST

Undocumented dbms_sqltcb_internal.i_replay_bind_list( directory IN VARCHAR2, bndlstfile IN VARCHAR2, BIND_LIST OUT sys.sql_binds);

TBD

I_REPLAY_SQL_TESTCASE

Undocumented dbms_sqltcb_internal.i_replay_sql_testcase( directory IN VARCHAR2, sqltestcase IN CLOB, sql_stmt IN sys.sqlset_row, ctrloptions IN VARCHAR2, replmode IN VARCHAR2, format IN VARCHAR2, testcase_name IN VARCHAR2) RETURN CLOB;

I_SET_TRACING

TRUE enables tracing, FALSE disables dbms_sqltcb_internal.i_set_tracing(status IN BOOLEAN);

exec dbms_sqltcb_internal.i_set_tracing(TRUE);

      

      PL/SQL procedure successfully completed.

I_TCB_CHECK_REPLAY_PARAMETERS

Undocumented dbms_sqltcb_internal.i_tcb_check_replay_parameters( CTRLOPTIONS IN VARCHAR2, FORMAT IN VARCHAR2) RETURN VARCHAR2;

I_TCB_HAS_DYN_STS

Returns TRUE if TCB Dynamic Statistics are enabled dbms_sqltcb_internal.i_tcb_has_dyn_sts RETURN BOOLEAN;

BEGIN

        IF dbms_sqltcb_internal.i_tcb_has_dyn_sts THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

I_TCB_INIT_SCRIPT_PREFIX

Undocumented dbms_sqltcb_internal.i_tcb_init_script_prefix( testcase_name IN VARCHAR2, sql_id IN VARCHAR2);

TBD

I_VALIDATE_INCIDENTID

Undocumented dbms_sqltcb_internal.i_validate_incidentid(id IN VARCHAR2) RETURN VARCHAR2;

TBD

UPCASE

Undocumented dbms_sqltcb_internal.upcase( inname IN VARCHAR2, outname OUT VARCHAR2);

DECLARE

       inVal  VARCHAR2(30) := 'uwclass';

       outVal VARCHAR2(30);

      BEGIN

        dbms_output.put_line(inVal);

        dbms_sqltcb_internal.upcase(inVal,  OutVal);

        dbms_output.put_line(OutVal);

      END;

      /

      uwclass

      UWCLASS

      

      PL/SQL procedure successfully completed.