Thursday 22 August 2013

How to select value of profile through query

=================================
select fnd_profile.VALUE ( 'XXAJ_ALAM_TEST_SERVER_URL' )
into v_var
from dual;

or use this in plsql block :

v_var1 := fnd_profile.VALUE ( 'XXAJ_ALAM_TEST_SERVER_URL' );
=================================

Ur's
AmarAlam

0 comments:

Post a Comment