[Home] [Help]
265: PRAGMA AUTONOMOUS_TRANSACTION;
266: BEGIN
267: g_progressCounter := g_progressCounter+1;
268:
269: INSERT INTO BSC_TMP_BIG_IN_COND(session_id, VARIABLE_ID, VALUE_N, VALUE_V)
270: values (USERENV('SESSIONID'), -200, g_progressCounter,
271: pStage||' '||pMessage||' '||bsc_mo_helper_pkg.get_time);
272: commit;
273: EXCEPTION WHEN others then
1023: BEGIN
1024: gGAA_RUN_MODE := p_runMode;
1025: g_retcode := 0;
1026: g_processID := p_processID;
1027: delete bsc_tmp_big_in_cond where variable_id = -200;
1028: Setup;
1029: Init_Locks;
1030: Initialize;
1031: run_metadata_optimizer_pvt;