1351:
1352: begin
1353: -- get database sid
1354: begin
1355: /* We will get this from GLOBAL_NAME table instead of v$parameter
1356: select value
1357: into l_sid
1358: from v$parameter
1359: where name='db_name';
1357: into l_sid
1358: from v$parameter
1359: where name='db_name';
1360: */
1361: select global_name
1362: into l_sid from global_name;
1363: exception
1364: when no_data_found then
1365: l_sid := 'EVENTSYSTEM';
1358: from v$parameter
1359: where name='db_name';
1360: */
1361: select global_name
1362: into l_sid from global_name;
1363: exception
1364: when no_data_found then
1365: l_sid := 'EVENTSYSTEM';
1366: end;