DBA Data[Home] [Help]

APPS.BIS_MV_REFRESH dependencies on V$INSTANCE

Line 268: select version into db_versn from v$instance;

264: IS
265: db_versn varchar2(100);
266: l_atomic_refresh boolean;
267: BEGIN
268: select version into db_versn from v$instance;
269: BIS_COLLECTION_UTILITIES.put_line('DB Version: ' || db_versn);
270:
271: select substr(replace(substr(version,1,instr(version,'.',1,2)-1),'.'),1,2)
272: into db_versn from v$instance;

Line 272: into db_versn from v$instance;

268: select version into db_versn from v$instance;
269: BIS_COLLECTION_UTILITIES.put_line('DB Version: ' || db_versn);
270:
271: select substr(replace(substr(version,1,instr(version,'.',1,2)-1),'.'),1,2)
272: into db_versn from v$instance;
273:
274:
275: if (( db_versn > 80) and (db_versn < 90)) -- 8i
276: then