DBA Data[Home] [Help]

APPS.FND_TRACE dependencies on V$INSTANCE

Line 33: select substr(version,1,instr(version,'.')-1) into versn from v$instance;

29:
30: function GET_DB_VERSION return NUMBER IS
31: versn number:=8;
32: BEGIN
33: select substr(version,1,instr(version,'.')-1) into versn from v$instance;
34: return versn;
35: EXCEPTION
36: WHEN OTHERS THEN
37: return 8; -- Just in case, default it to 8

Line 459: FROM v$instance;

455: -- Check the database version.
456: -- version >= 11gR2 add plan_stat=adaptive
457: SELECT REPLACE(SUBSTR(version,1,instr(version,'.',1,2)-1),'.')
458: INTO db_versn
459: FROM v$instance;
460:
461:
462:
463: EXECUTE IMMEDIATE 'alter session set max_dump_file_size=unlimited';