Profile options set in an instance

Situation

You have Oracle ERP in two instances. And your requirement is to compare the Profile options set in two different instances and find the differences.

Workaround

Firstly you need to get the Profile options set in each of the instance. For that, Create a function. Get the query from Profile Options table and than hard code the  Profile Option name then get the value from that query.

Function is created as below:

CREATE OR REPLACE FUNCTION xxtest_sql(p_qry IN VARCHAR2,p_val IN VARCHAR2,p_name VARCHAR2) RETURN VARCHAR2 IS

lv_qry VARCHAR2(4000) := p_qry;

lv1 VARCHAR2