The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 06-03-2004
ap_gore79 ap_gore79 is offline
Registered User
  
 

Join Date: Jun 2004
Posts: 5
Thumbs down return variable from PL/SQL procedure to shell

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(UM_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.






Last edited by ap_gore79; 06-03-2004 at 05:52 PM..