<div>
Thanks.<br />
That way worked.<br />
<br />
Is there any way that can actually supress it from sqlplus?
</div>


Thanks.
That way worked.

Is there any way that can actually supress it from sqlplus?

<div>
sorry, dont know about that
</div>


<div>
FYI:<br />
<br />
set FEEDBACK OFF;<br />
<br />
will do it<br />
<br />
Thanks all the same.
</div>


FYI:

set FEEDBACK OFF;

will do it

Thanks all the same.

<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp;I want to return a value from a oracle stored procedure. <br />
<br />
&nbsp;VALUE=` ${ORACLE_HOME}/bin/sqlplus<wbr /> -s &nbsp; &lt;&lt;-EOF<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ${ORA_USER}/${ORA_PASSWORD<wbr />}<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; @${SQL_SCRIPT}<br />
&nbsp; &nbsp; &nbsp; &nbsp; EOF`<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; echo $VALUE<br />
<br />
<br />
I am doing the above, however $VALUE always contains &quot;PL/SQL procedure completed successfully&quot;. Is there anyway to supress that last bit? and just return the actual value.<br />

</div>
</div>


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.


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

Kernel and system programming is the process of creating the software necessary for a computer or device to function and operate other programs. Some operating systems (such as Microsoft Windows) are proprietary, but others, such as the various Linux distributions, are open source.