21: l_oracle_schema := 'JTF';
22: end if;
23:
24: retcode := 0;
25: --ad_ctx_ddl.sync_index(idx_name => 'JTF.JTF_TASKS_TL_IM');
26: ad_ctx_ddl.sync_index(idx_name => l_oracle_schema||'.JTF_TASKS_TL_IM');
27: EXCEPTION
28: WHEN OTHERS THEN
29: errbuf := SUBSTR(SQLERRM, 1, 80);
22: end if;
23:
24: retcode := 0;
25: --ad_ctx_ddl.sync_index(idx_name => 'JTF.JTF_TASKS_TL_IM');
26: ad_ctx_ddl.sync_index(idx_name => l_oracle_schema||'.JTF_TASKS_TL_IM');
27: EXCEPTION
28: WHEN OTHERS THEN
29: errbuf := SUBSTR(SQLERRM, 1, 80);
30: retcode := 2;