sqlplus session being able to see unix variables session within a script

435 Gavea · #1 (**permalink**) 06-29-2006

Hi there.
How do I make the DB connection see the parameter variables passed to the unix script ? The code snippet below isn't working properly.

sqlplus << EOF
user1@db1/pass1

BEGIN
PACKAGE1.perform_updates($1,$2,$3);
END;

EOF

Thanks in advance,
Abrahao.

jim mcnamara · #2 (**permalink**) 06-29-2006

Code:

sqlplus user1@db1/pass1 << EOF
BEGIN
PACKAGE1.perform_updates($1,$2,$3);
END;
/

EOF

Assuming your PL/SQL works - did you try it? - I added a slash, because it could not have worked without it.

435 Gavea · #3 (**permalink**) 07-03-2006

the slash was the problem, now the variables are getting into the package.
thanks!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Recording a UNIX Session	amitkhiare	Shell Programming and Scripting	0	01-13-2008 03:00 AM
Running a script without a terminal session	jjinno	Shell Programming and Scripting	3	10-03-2007 01:50 AM
Unix Telnet session	mlucas	UNIX for Dummies Questions & Answers	2	08-17-2006 10:26 AM
unix session	thomaso	Shell Programming and Scripting	6	03-20-2006 01:38 PM
Terminate session on completing script	deepsteptom	Shell Programming and Scripting	4	06-08-2004 10:47 AM

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


	Powered by