error connecting to sqlplus

papachi · #1 (**permalink**) 05-23-2005

Hi,
I wrote a shell script to call oracle procedure. But when i am trying to connet sqlplus with the fallowing statement It is giving me error " callproce.sh : sqlplus: not found". What could be the problem.
sqlplus -s $CONNECT_STRING >$LOGFILE <<!!

thank u all
papachi

plimpix · #2 (**permalink**) 05-23-2005

Looks like you don't have the binary set in the PATH, if you use the full path i.e.

/usr/local/bin/sqlplus

That should work, all depends where the binary is installed.

P

papachi · #3 (**permalink**) 05-23-2005

Thank u very much. it worked

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
SQLPLUS error	ssmith001	Shell Programming and Scripting	3	07-22-2008 01:00 PM
error connecting database from perl	DILEEP410	Shell Programming and Scripting	4	09-17-2007 09:03 AM
error connecting to wmserver	zuessh	AIX	2	11-21-2006 12:03 PM
Error in connecting PPP connection	nagendrajaiswal	UNIX for Dummies Questions & Answers	2	07-15-2006 03:58 AM
sqlplus -s error capture	w33man	Shell Programming and Scripting	1	03-05-2004 04:26 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 Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by