Re: call sql oracle 8.i with unix script fails

On Jan 12, 6:45 pm, "Ed Yin" <vraa..._at_hotmail.nl> wrote:
> hello,
>
> maybe someone can help me out on this script it will only execute 1 sql
> statement depending on what file_name what is wrong with what i am trying to
> do?
>
> i try to call a sql like this depending on interface type
>
> this shell is called rim started like this ./rim POR AL where POR
> is type en AL = $2 file name in this test
>
> $1=INTTYPE
> file_name='test.por'
> typeO=ORD
> typeP=POR
>
> if $1=$typeO
> then
> sqlplus -s / @ord_controle.sql $2 $file_name <<F /
> echo processing $typeO $1 $sql1 $file_name
> else $1=$typeP
> sqlplus -s / @por_controle.sql $2 $file_name <<F /
> echo processing $typeP $1 $sql2 $file_name
> show errors;
> F
> fi
> exit 0
>
> thanks Ed

You check a variable's value like this (assuming sh/ksh/bash i.e. not csh)

if [[ $1 = $typeO ]]

A here-document is defined like this:

sqlplus -s / <<END_SQL
prompt Connected to SQL*Plus
prompt HOME = $HOME
prompt Exiting SQL*Plus...
exit
END_SQL The terminating token ("END_SQL" in my example) has to match the whole line, so no leading or trailing whitespace or any other characters. You can extend this to allow leading tabs (not spaces) by placing a dash immediately before it in the opening line, i.e.

sqlplus -s / <<-END_SQL

It is valid to call a SQL*Plus script on the command line although like Ana I don't recall seeing anyone do this. The specified script would be called first, then any other commands in the here-document.

It seems you have two alternative sqlplus command lines and your shell script is attempting to execute one or the other (or both?). However the only difference between them seems to be the name of the script file. An obvious simplification would be to put that in a variable and call just one command line. Received on Sun Jan 14 2007 - 10:01:36 CST