Oracle | DBMS_SQLTCB

Oracle DBMS_SQLTCB_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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.