<div>
Did you try?!<br />
<br />

<pre><code id="code-20-40646378-1">Result=`sqlplus -s userid/passwd &lt;&lt;EOSQL
var var1 number;
exec myProc( :var1 out number, :var2 out number);
print :var1
print :var2
exit
EOSQL`</code></pre>
</div>


Did you try?!



Result=`sqlplus -s userid/passwd <<EOSQL
var var1 number;
exec myProc( :var1 out number, :var2 out number);
print :var1
print :var2
exit
EOSQL`

<div>
So both the out parameters will be stored in variable $Result?
</div>


So both the out parameters will be stored in variable $Result?

<div>
Its works fine for me . Thanks for your help.
</div>


Its works fine for me . Thanks for your help.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Reference to post: <a href="https://www.experts-exchange.com/questions/28605273/Oracle-help-with-Linux.html" rel="ugc">https://www.experts-exchange.com/questions/28605273/Oracle-help-with-Linux.html</a><br />
Solution id:ID: <a href="https://www.experts-exchange.com/questions/28605273/Oracle-help-with-Linux.html?anchorAnswerId=40575654#a40575654" rel="ugc">40575654</a><br />
<br />
If i have 2 out parameters ,how can i get them both in my shell variables.<br />
<br />
Thanks
</div>
</div>


Hi,

Reference to post: http://www.experts-exchange.com/Database/Oracle/Q_28605273.html
Solution id:ID: 40575654 (https://www.experts-exchange.com/questions/28605273/Oracle-help-with-Linux.html?anchorAnswerId=40575654#a40575654)

If i have 2 out parameters ,how can i get them both in my shell variables.

Thanks

oracle get many out  params from procedures

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.