PalanikumarMariappan603811

job not running properly in the workflow.

Discussion created by PalanikumarMariappan603811 on Jan 19, 2016
Latest reply on Feb 4, 2016 by PalanikumarMariappan603811
In an unix job i am connecting to a oracle db and fetch some distinct values into an unix variable.  This is not pushing values to the unix variable when i run this job inside a workflow.  but working perfect when run as adhoc.
.
.
.
$ORACLE_HOME/bin/sqlplus -s $CONNECT <<-EOF >$***
SET HEADING OFF
SET FEEDBACK OFF
SET PAGESIZE 0
select distinct y.a
from tab_a y
where y.status = 'X' 
QUIT;
EOF 
.
.
.

Outcomes