1288: if l_plsql_call is not null
1289: then
1290: begin
1291: l_plsql_call := l_plsql_call||'(p_session_id => '||l_session_id||', p_plug_id => '||p.plug_id||', p_delete => ''Y'')';
1292: l_call := dbms_sql.open_cursor;
1293: dbms_sql.parse(l_call,'begin '||l_plsql_call||'; end;',dbms_sql.native);
1294: l_dummy := dbms_sql.execute(l_call);
1295: dbms_sql.close_cursor(l_call);
1296: exception
1289: then
1290: begin
1291: l_plsql_call := l_plsql_call||'(p_session_id => '||l_session_id||', p_plug_id => '||p.plug_id||', p_delete => ''Y'')';
1292: l_call := dbms_sql.open_cursor;
1293: dbms_sql.parse(l_call,'begin '||l_plsql_call||'; end;',dbms_sql.native);
1294: l_dummy := dbms_sql.execute(l_call);
1295: dbms_sql.close_cursor(l_call);
1296: exception
1297: when others then
1290: begin
1291: l_plsql_call := l_plsql_call||'(p_session_id => '||l_session_id||', p_plug_id => '||p.plug_id||', p_delete => ''Y'')';
1292: l_call := dbms_sql.open_cursor;
1293: dbms_sql.parse(l_call,'begin '||l_plsql_call||'; end;',dbms_sql.native);
1294: l_dummy := dbms_sql.execute(l_call);
1295: dbms_sql.close_cursor(l_call);
1296: exception
1297: when others then
1298: l_count := l_count;
1291: l_plsql_call := l_plsql_call||'(p_session_id => '||l_session_id||', p_plug_id => '||p.plug_id||', p_delete => ''Y'')';
1292: l_call := dbms_sql.open_cursor;
1293: dbms_sql.parse(l_call,'begin '||l_plsql_call||'; end;',dbms_sql.native);
1294: l_dummy := dbms_sql.execute(l_call);
1295: dbms_sql.close_cursor(l_call);
1296: exception
1297: when others then
1298: l_count := l_count;
1299: end;