The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Google UNIX.COM


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here.

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-12-2008 11:00 PM
Running a script without a terminal session jjinno Shell Programming and Scripting 3 10-02-2007 10:50 PM
Unix Telnet session mlucas UNIX for Dummies Questions & Answers 2 08-17-2006 07:26 AM
unix session thomaso Shell Programming and Scripting 6 03-20-2006 09:38 AM
Terminate session on completing script deepsteptom Shell Programming and Scripting 4 06-08-2004 07:47 AM

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-29-2006
Registered User
 

Join Date: Oct 2003
Location: Brazil
Posts: 42
Stumble this Post!
sqlplus session being able to see unix variables session within a script

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.
Reply With Quote
Forum Sponsor
  #2 (permalink)  
Old 06-29-2006
...@...
 

Join Date: Feb 2004
Location: NM
Posts: 3,808
Stumble this Post!
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.
Reply With Quote
  #3 (permalink)  
Old 07-03-2006
Registered User
 

Join Date: Oct 2003
Location: Brazil
Posts: 42
Stumble this Post!

the slash was the problem, now the variables are getting into the package.
thanks!
Reply With Quote
Google The UNIX and Linux Forums
Reply

Thread Tools
Display Modes




All times are GMT -7. The time now is 12:21 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0