DBA Data[Home] [Help]

DVSYS.EVENT dependencies on DATABASE_NAME

Line 6: P_DATABASE_NAME VARCHAR2,

2:
3: PROCEDURE set_c (P_SYSEVENT VARCHAR2,
4: P_LOGIN_USER VARCHAR2,
5: P_INSTANCE_NUM VARCHAR2,
6: P_DATABASE_NAME VARCHAR2,
7: P_DICT_OBJ_TYPE VARCHAR2,
8: P_DICT_OBJ_OWNER VARCHAR2,
9: P_DICT_OBJ_NAME VARCHAR2,
10: P_SQL_TEXT VARCHAR2)

Line 19: P_DATABASE_NAME, P_DATABASE_NAME INDICATOR,

15: PARAMETERS (CONTEXT,
16: P_SYSEVENT, P_SYSEVENT INDICATOR,
17: P_LOGIN_USER, P_LOGIN_USER INDICATOR,
18: P_INSTANCE_NUM, P_INSTANCE_NUM INDICATOR,
19: P_DATABASE_NAME, P_DATABASE_NAME INDICATOR,
20: P_DICT_OBJ_TYPE, P_DICT_OBJ_TYPE INDICATOR,
21: P_DICT_OBJ_OWNER, P_DICT_OBJ_OWNER INDICATOR,
22: P_DICT_OBJ_NAME, P_DICT_OBJ_NAME INDICATOR,
23: P_SQL_TEXT, P_SQL_TEXT INDICATOR);

Line 28: P_DATABASE_NAME VARCHAR2,

24:
25: PROCEDURE set (P_SYSEVENT VARCHAR2,
26: P_LOGIN_USER VARCHAR2,
27: P_INSTANCE_NUM NUMBER,
28: P_DATABASE_NAME VARCHAR2,
29: P_DICT_OBJ_TYPE VARCHAR2,
30: P_DICT_OBJ_OWNER VARCHAR2,
31: P_DICT_OBJ_NAME VARCHAR2,
32: P_SQL_TEXT VARCHAR2) AS

Line 51: dvsys.event.set_c(P_SYSEVENT, l_loginuser, l_instancenum, P_DATABASE_NAME,

47: ELSE
48: l_sqltext := '';
49: END IF;
50:
51: dvsys.event.set_c(P_SYSEVENT, l_loginuser, l_instancenum, P_DATABASE_NAME,
52: P_DICT_OBJ_TYPE, P_DICT_OBJ_OWNER, P_DICT_OBJ_NAME, l_sqltext);
53: END;
54:
55: PROCEDURE setdefault AS

Line 57: dvsys.event.set(SYS.SYSEVENT, SYS.LOGIN_USER, SYS.INSTANCE_NUM, SYS.DATABASE_NAME,

53: END;
54:
55: PROCEDURE setdefault AS
56: BEGIN
57: dvsys.event.set(SYS.SYSEVENT, SYS.LOGIN_USER, SYS.INSTANCE_NUM, SYS.DATABASE_NAME,
58: SYS.DICTIONARY_OBJ_TYPE, SYS.DICTIONARY_OBJ_OWNER, SYS.DICTIONARY_OBJ_NAME, '');
59: END;
60: END event;