> Set linesize variable to avoid unwanted spaces
Ex:
--
lc_rti_rec=`sqlplus -s $orauser_pwd <<+ENDOFSQL+
set feedback off
set echo off
set pages 0
set heading off
set verify off
set termout off
set feed off
set trimspool on
set trim on
set linesize 100
select fcr.outfile_name
||'#'||
(select instance_name FROM v\\$instance)
from fnd_concurrent_requests fcr
where fcr.priority_request_id = $ln_request_id;
exit
+ENDOFSQL+`
lc_out_file=`echo $lc_rti_rec | cut -f1 -d'#'`
echo "Output Directory>"
echo $lc_out_file
echo " "
lc_instance=`echo $lc_rti_rec | cut -f2 -d'#'`
echo "Instance>"
echo $lc_instance
echo " "
--
Ref: My Experience/Oracle Metalink/User Guides/Different other blogs available/Colleagues
Ex:
--
lc_rti_rec=`sqlplus -s $orauser_pwd <<+ENDOFSQL+
set feedback off
set echo off
set pages 0
set heading off
set verify off
set termout off
set feed off
set trimspool on
set trim on
set linesize 100
select fcr.outfile_name
||'#'||
(select instance_name FROM v\\$instance)
from fnd_concurrent_requests fcr
where fcr.priority_request_id = $ln_request_id;
exit
+ENDOFSQL+`
lc_out_file=`echo $lc_rti_rec | cut -f1 -d'#'`
echo "Output Directory>"
echo $lc_out_file
echo " "
lc_instance=`echo $lc_rti_rec | cut -f2 -d'#'`
echo "Instance>"
echo $lc_instance
echo " "
--
Ref: My Experience/Oracle Metalink/User Guides/Different other blogs available/Colleagues
No comments:
Post a Comment