Oracle | DBMS_SQLTCB

Oracle DBMS_SQLTCB_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Believed related to incident reporting

AUTHID CURRENT_USER

Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_SQLTCB_INTERNAL' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_SQLTCB_INTERNAL' ORDER BY 1;

Returns 55 objects

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_GENERATE_SQL_TESTCASE	I_SET_TRACING
I_CAPTURE_BIND_LIST	I_GET_FILE_NAME	I_TCB_CHECK_REPLAY_PARAMETERS
I_CLOB_LOAD	I_GET_SQL	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
I_EXPLAIN_SQL_TESTCASE

FIXQ

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

SELECT dbms_sqltcb_internal.fixq('ZZYZX');

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_GET_SQL (new 23ai)

Undocumented dbms_sqltcb_internal.i_get_sql( sql_id IN VARCHAR2, plan_hash_value IN NUMBER, sqlset_rec OUT sys.sqlset_row, exec_user_id OUT NUMBER) RETURN BOOLEAN;

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;

TBD

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;

TBD

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.