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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.