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 (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.

Related Topics
Built-in Functions
Built-in Packages
Database Security
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx