Technical‎ > ‎Scripts‎ > ‎

Oracle e-business How to Obtain Environment Variable value using sql query



There is a very simple query to find the environment variable being used by a concurrent program:

SELECT variable_name,
       VALUE
  FROM apps.fnd_env_context
 WHERE variable_name in ('AF_CLASSPATH','CLASSPATH','JAVA_TOP') 
   AND concurrent_process_id =
       (SELECT MAX(concurrent_process_id)
          FROM apps.fnd_env_context)
 ORDER BY 1;










Free Hit Counters