SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMSOBJG'
UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMSOBJG'
ORDER BY 1;
CHECK_PERMISSIONS
Undocumented
Verifies that the named object exists in the named schema and is the type
identified object type
check_permissions(
sname IN VARCHAR2,
oname IN VARCHAR2,
type IN VARCHAR2);
dbmsobjg.find_col_info(
column_name IN VARCHAR2,
coltab IN dbms_utility.coltab) RETURN
NUMBER;
set serveroutput on
DECLARE
coltb dbms_utility.name_array;
i NUMBER;
BEGIN
coltb(1) := 'UWCLASS.SERVERS';
coltb(2) := 'UWCLASS.SERV_INST';
i := dbmsobjg.find_col_info('SRVR_ID',
coltb);
dbms_output.put_line(TO_CHAR(i));
END;
/
FIND_TS_INFO
Undocumented
Finds some type of information about
tablespaces
dbmsobjg.find_ts_info(
tablespace_name IN VARCHAR2(30),
tstab IN
dbmsobjg.tspace_tab,
tscnt IN
NUMBER) RETURN NUMBER;
set servertoutput on
DECLARE
tstab dbmsobjg.tspace_tab;
tscnt NUMBER(3);
i NUMBER;
BEGIN
dbmsobjg.get_tab_space('UWCLASS','AIRPLANES','TABLE',tstab, tscnt);
i := dbmsobjg.find_ts_info('UWDATA',
tstab, tscnt);
dbms_output.put_line(TO_CHAR(i));
END;
/
GENERATE_DDL
Undocumented
Overload 1
dbmsobjg.generate_ddl(
sname ?
?,
oname IN
VARCHAR2,
type IN
VARCHAR2,
flavor_columns IN name_array,
tablespace IN VARCHAR2,
ddltab IN VARCHAR2S,
ddllentab IN number_array,
use_tablespace IN VARCHAR2,
create_storage IN VARCHAR2,
disabled_trig OUT VARCHAR2,
force_view IN VARCHAR2,
debug_table IN VARCHAR2,
ddlcnt OUT NUMBER,
tstab IN
tspace_tab,
tscnt IN
NUMBER);
set linesize 121
col argument_name format a20
col position format 99
col data_type format a15
col in_out format a6
col type_owner format a12
col type_name format a20
col type_subname format a20
SELECT argument_name, position, data_type, in_out, type_owner, type_name, type_subname
FROM all_arguments
WHERE object_name = 'GENERATE_DDL'
AND package_name = 'DBMSOBJG'
AND overload = 1
ORDER BY position, data_level;
Overload 2
dbmsobjg.generate_ddl(
sname
? ?,
oname
IN VARCHAR2,
type
IN VARCHAR2,
flavor_columns IN name_array,
tablespace
IN VARCHAR2,
ddltab
IN OUT VARCHAR2S,
use_tablespace IN VARCHAR2,
create_storage IN VARCHAR2,
disabled_trig OUT VARCHAR2,
disabled_trig_ddl IN OUT VARCHAR2S,
force_view
IN VARCHAR2,
debug_table IN
VARCHAR2,
ddlcnt
IN OUT NUMBER,
disabledcnt IN OUT NUMBER,
tstab
IN tspace_tab,
tscnt
IN NUMBER);
set linesize 121
col argument_name format a20
col position format 99
col data_type format a15
col in_out format a6
col type_owner format a12
col type_name format a20
col type_subname format a20
SELECT argument_name, position, data_type, in_out, type_owner, type_name, type_subname
FROM all_arguments
WHERE object_name = 'GENERATE_DDL'
AND package_name = 'DBMSOBJG'
AND overload = 2
ORDER BY position, data_level;
GET_NLS_SUBSTR
Undocumented
dbmsobjg.get_nls_substr(
s IN VARCHAR2,
offset IN OUT NUMBER,
len IN NUMBER) RETURN VARCHAR2;
set serveroutput on
DECLARE
ofs NUMBER := 3;
x VARCHAR2(100);
BEGIN
x := dbmsobjg.get_nls_substr('ZZDUALZZ',
ofs, 4);
Free