SQL & PL/SQL

Hi All,

How to get the FND_PROFILE.VALUE('ORG_ID')  in host program.

I did like below but it failed.

v_return='$ORACLE_HOME/bin/sqlplus -s $FCP_LOGIN <<END

                  set pagesize 0

                 set echo off

                 fnd_profile.value('ORG_ID');

                EXIT;

END'

echo $v_return

but it error with message:  Retrun Value SP -0734 : Unknow command beginning "fnd_profile...."

Regards,

Uva