Shell script which runs sql script

Geller · #1 (**permalink**) 11-14-2008

Hi all,

I need a shell script which runs a sql script but I couldn't find how to finish it. This is the code that I have:

#! /usr/bin/ksh
export SHELL=/bin/ksh
export ORACLE_SID=database
export ORACLE_HOME=/opt/oracle/product/9.2.0.8
sqlplus user[/password][@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=database)(PORT=1637))(CONNECT_DATA=(SERVICE_NAME=database )))] [AS {SYSOPER}] <<EOF @/path/path/path/scriptname.sql
EXIT
EOF

When I run this code I am receiving the next message error:

Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
<logon> ::= <username>[/<password>][@<connect_string>] | / | /NOLOG
<start> ::= @<URI>|<filename>[.<ext>] [<parameter> ...]
"-H" displays the SQL*Plus version banner and usage syntax
"-V" displays the SQL*Plus version banner
"-L" attempts log on just once
"-M <o>" uses HTML markup options <o>
"-R <n>" uses restricted mode <n>
"-S" uses silent mode

Any idea what I should change?

Thank you!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
create a shell script that calls another script and and an awk script	magikminox	Shell Programming and Scripting	0	06-26-2008 02:50 AM
Sunsolaris shell script runs only as super user	gjithin	SUN Solaris	4	05-09-2008 08:47 AM
Script runs fine on UNIX Server...Not through MSK Tool kit on Windows Server	madhunk	UNIX for Dummies Questions & Answers	5	01-31-2008 01:30 PM
Shell Script: want to insert values in database when update script runs	ring	Shell Programming and Scripting	1	10-25-2007 03:06 AM
My script runs too slow :-(...	roybe	UNIX for Advanced & Expert Users	0	06-13-2005 12:54 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:


	Powered by