oracle get many out params from procedures

Hi,

Reference to post: https://www.experts-exchange.com/questions/28605273/Oracle-help-with-Linux.html
Solution id:ID: 40575654

If i have 2 out parameters ,how can i get them both in my shell variables.

Thanks

Oracle Database

Last Comment

magento

8/22/2022 - Mon

Alex [***Alex140181***]

3/5/2015

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`

magento

3/5/2015

ASKER

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

ASKER CERTIFIED SOLUTION

3/5/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

magento

3/19/2015

ASKER

Its works fine for me . Thanks for your help.