supress PL/SQL procedure completed ... Return value from sql plus

Hi,
 I want to return a value from a oracle stored procedure.

 VALUE=` ${ORACLE_HOME}/bin/sqlplus -s   <<-EOF
                ${ORA_USER}/${ORA_PASSWORD}
                @${SQL_SCRIPT}
        EOF`

        echo $VALUE


I am doing the above, however $VALUE always contains "PL/SQL procedure completed successfully". Is there anyway to supress that last bit? and just return the actual value.
mash79Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sunnycoderConnect With a Mentor Commented:
Hi mash79,

var=`echo $VALUE | sed 's/PL\/SQL procedure completed successfully//'`
echo $var

Sunnycoder
0
 
mash79Author Commented:
Thanks.
That way worked.

Is there any way that can actually supress it from sqlplus?
0
 
sunnycoderCommented:
sorry, dont know about that
0
 
mash79Author Commented:
FYI:

set FEEDBACK OFF;

will do it

Thanks all the same.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.