Insert statement from Unix shell script

[badrinathn]

Hi,

I am trying to write a shell script where some
values are stored in the variables and the same variables
needs to be stored in the database.

eg: I have $LOGREAD, $LOGREG, $LOGDIS (all having different values). I want to insert these values from the shell script and so

I am doing the follwoing

sqlplus -s gimdev2/gimdev2@cendexpi < insert into control_table
(dfile,dreg,ddis)
values
($LOGREG,$LOGDIS,$LOGDIS)
;
commit;
EOF


This part of the code is giving me SP2-0552 errors, and I am not sure how to make it work from shell script.


Any suggestions.

Badrinath

[marcio.68]

Try it places script of insert in a separate archive

sqlplus -s gimdev2/gimdev2@cendexpi @/source/insert.sql

[badrinathn]

Hi,

Thanks, but I know how to do by passing variables to the external .sql file.

But just wanted to know if I can work in this way when I just invoke the sqlplus and use the shell variables.

Badrinath

[rotem_fo]

Here's an example of csh script:

-------------------- Code Starts Here ------------------

#!/bin/csh -fb
######################################

# Initialize variables
set LOGREG = ""
set LOGDIS = ""

# Collect the variables you want to set
while ($#argv > 0)
switch ($argv[1])
case ...
endsw
shift argv
end


sqlplus -s gimdev2/gimdev2@cendexpi << EOF
-- if values inserted are varchar2 type use '$LOGREG' instead of $LOGREG
insert into control_table(dfile,dreg,ddis) values ($LOGREG,$LOGDIS,$LOGDIS);
commit;
EOF

-------------------- Code Ends Here ------------------

Ejnoy,

[badrinathn]

That was my first approach but it came out with
SP2-0552 errors