Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

SQL in shell script

Comment:

Hi i have written a shell script which runs some sql queries in oracle. the code looks like this sqlplus username@NJCMTOMS/password < $HOME/devel/oms/arg/cleanupsql.sh cleanupsql.sh has the sqls to be executed. This works fine if i run from the prompt but when i run from a cron,then cron is not able to find sqlplus.i also tried giving the absolute path for sqlplus ,still no success.

Reply:

Hi: This is a common problem with any shell script that runs fine from the command line, but fails from cron. You need to set up your environment in the script - primarily PATH and any environmental variables ORACLE requires. Regards, Nails

0

Oracle Lib Error

ata0: Resetting Devices.....

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: In shell script I am inserting the record in to the table.After excuation the script output is commit complete which is fine but I need my echo should be display like "Account created" #!/bin/ksh . . ...

Summary: Richard: I'm not an Oracle guy, but check out "Using SQL in Shell Scripts" by Gleed and Tarvainen: http://www.samag.com/documents/s=1434/sam9505f/9505f.htm Regards, Nails ...

Summary: Hi, I'm trying to run loops in shell scripts using the following script. loop=1 while [ loop -lt 10 ] do echo 'this is my $loop text-line' loop='expr $loop + 1' done ---- but I'm getting error: test: ...