DBA Data[Home] [Help]

SYS.OLAP_API_SESSION_INIT dependencies on DBMS_OUTPUT

Line 42: DBMS_OUTPUT.PUT_LINE('Row inserted');

38: alterStmt := 'ALTER SESSION ' || UPPER(sqlStmt);
39: isNewRole := newRole(role_num, alterStmt);
40: IF isNewRole = 0 THEN
41: INSERT INTO SYS.OLAP$ALTER_SESSION (ROLE#, TEXT) VALUES (role_num, alterStmt);
42: DBMS_OUTPUT.PUT_LINE('Row inserted');
43: COMMIT;
44: ELSE
45: RAISE duplicate_role;
46: END IF;

Line 57: DBMS_OUTPUT.PUT_LINE('Unknown exception occured');

53: RAISE_APPLICATION_ERROR(-20002,
54: 'ALTER SESSION command already exists for ' || roleName);
55: RAISE duplicate_role;
56: WHEN OTHERS THEN
57: DBMS_OUTPUT.PUT_LINE('Unknown exception occured');
58: END add_alter_session;
59:
60: PROCEDURE delete_alter_session (roleName VARCHAR2, sqlStmt VARCHAR2) IS
61: role_num INT;

Line 77: DBMS_OUTPUT.PUT_LINE('Unknown exception occured');

73: WHEN NO_DATA_FOUND THEN
74: RAISE_APPLICATION_ERROR(-20001, roleName || ' is not a valid role');
75: RAISE invalid_role;
76: WHEN OTHERS THEN
77: DBMS_OUTPUT.PUT_LINE('Unknown exception occured');
78: END delete_alter_session;
79:
80: PROCEDURE clean_alter_session IS
81: BEGIN