Re: Running an SQL script from C Shell (Unix)

use a real shell like sh or korn
and a "here document" this also hides the user/password. But you could pass in parameters if needed.

sqlplus << EOF
user/password
select blah from bleah;
exit;
EOF

-- 


---------------------------------------------------------

Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.tc.umn.edu/~hause011


---------------------------------------------------------