DBA Data[Home] [Help]

MDSYS.SDO_GEOR_ADDL_TRIGGER dependencies on STANDARD

Line 23: m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual';

19: if ( m_cnt != 0 ) then
20: return;
21: end if;
22:
23: m_stmt:='select sys.dbms_standard.dictionary_obj_type from dual';
24: execute immediate m_stmt into m_type;
25: if(not (m_type='TABLE' or m_type='TRIGGER' or m_type='USER' or m_type='TABLESPACE'))
26: then
27: return;

Line 30: m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual';

26: then
27: return;
28: end if;
29:
30: m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual';
31: execute immediate m_stmt into m_owner;
32:
33: m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual';
34: execute immediate m_stmt into m_name;

Line 33: m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual';

29:
30: m_stmt:='select sys.dbms_standard.dictionary_obj_owner from dual';
31: execute immediate m_stmt into m_owner;
32:
33: m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual';
34: execute immediate m_stmt into m_name;
35:
36: m_stmt:='select sys.dbms_standard.sysevent from dual';
37: execute immediate m_stmt into m_event;

Line 36: m_stmt:='select sys.dbms_standard.sysevent from dual';

32:
33: m_stmt:='select sys.dbms_standard.dictionary_obj_name from dual';
34: execute immediate m_stmt into m_name;
35:
36: m_stmt:='select sys.dbms_standard.sysevent from dual';
37: execute immediate m_stmt into m_event;
38:
39:
40: