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