bsh => pl/sql

["Eric Chadbourne" <user=1528@nabble.blu.org>]

 Hi all.  I have a bash script and an sql script.  All works as I've made 
it but how could I combine them into one?  Here's an example. 

#!/bin/bash 

VAR1="$1" 
VAR2="$2" 

#some bash code here that outputs two variables 

-- now i want to switch into sql-land instead of listing the path to the 
sql file with two variables after it. 

/some/path/here/sqlplus $USR/$PASSWORD@ID 

begin 
   some_procedure(silly($1), eric($2)); 
end; 
/ 

It's not really important for me to get this done with one file, I was 
just wondering if it's possible. 

Thanks, 
Eric C. 

-- 
This message has been scanned for viruses and 
dangerous content by MailScanner, and is 
believed to be clean. 

_______________________________________________ 
Discuss mailing list 
[hidden email] 
http://lists.blu.org/mailman/listinfo/discuss