DBA Data[Home] [Help]

APPS.OKI_DBI_SCM_RSG_API_PVT dependencies on V$INSTANCE

Line 41: FROM v$instance;

37: ELSIF (l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.Type_Mv_Index_Mgt) THEN
38: --only manage indexes if db version is older than 10G
39: SELECT version
40: INTO l_version
41: FROM v$instance;
42:
43: IF substr(l_version,1,3) = '10.' THEN
44: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('The database version is '||l_version||' so no need for index management');
45: ELSE