Search Results

value="$(sqlplus -s username/password<<END
set feed off serveroutput on
exec gohan(7)
END
)"

Then i used echo $value

I used echo $value but the output was not displayed.

Thanks it works fine............I get the output "My lucky number is 7"

One more thing, Can I store this above output in a variable say 'value' and then when I give echo $value I want the same...

Hi,

My stored procedure returns a value.
How to retrieve the value and display in unix.

Stored procedure

CREATE OR REPLACE
PROCEDURE gohan(num INT) IS

BEGIN
...