return variable from PL/SQL procedure to shell

Shell Programming and Scripting
1

Hi
i'm calling a pl/sql procedure which is returning one variable.
i'm trying to assing this value to variable in shell script

the code i wrote is

** in shell script**
var= 'sqlplus user/pass @ret.sql'
echo $var

**

and

variable dum_var number
exec rt_test(:DUM_VAR);
exit;

in ret.sql

the error i'm getting is
sqlplus user/pass @ret.sql: not found.

Can somebody suggest me how to receive variable from plsql in shell.

:confused:

2

change var= 'sqlplus flex1/flex01 @ret.sql'
to

var= `sqlplus flex1/flex01 @ret.sql`

notice I substituted the single quotes with backticks (located above the tab key on a PC keyboard).

3

Here is a thread that describes another method --> Click Here

Also, search the boards...this question has been asked and answered a few times.

4

Thanks

It worked fine but still its giving error

SQL*Plus:: not found.

Do i need to export any variable such as ORACLE_HOME
or PATH

5

oh..

thanks it workd fine...

thanks for prompt reply....