Execution problem in shell script while insert into DB

UNIX Solaris
1

Hi,

am facing some problem while inserting a record into a script

Please find script below.

`sqlplus -s asdf/asdf123 <<eof!
set feedback off;
set heading off;
set verify off;

            insert into &lt;table\_name&gt;\(NNI,TECH\_MARKER,CURRENT\_FIELD\_BUILD\_ID,DEFAULT\_FIELD\_BUILD\_ID,CURRENT\_EMNAME,DEFAULT\_EMNAME,CURRENT\_CAP_OFFSET,PA

THFINDER,BB_FIRST_FLAG) values ('$nni','$TechM','$FBI','$FBI','T_Live','T_Live','6,3,5','$pathf','$bb_first');
commit;

               exit
           eof!\`

if [ "$scen" -eq 3 ] || [ "$scen" -eq 4 ]
then
`sqlplus -s asdf/asdf123 <<eof!
set feedback off
set heading off
set verify off

            insert into &lt;table\_name&gt;\(NNI,TECH\_MARKER,CURRENT\_FIELD\_BUILD\_ID,DEFAULT\_FIELD\_BUILD\_ID,CURRENT\_EMNAME,DEFAULT\_EMNAME,CURRENT\_CAP_OFFSET\) v

alues ('32008018','$TechM','AD-XONLY-LTS-21C','AD-XONLY-LTS-21C','T_Captive','T_Captive','7,6,5');
commit;
exit
eof!`
fi

when i try to execute am facing the following problem.

makePhDN: insert: not found
makePhDN: insert: not found

can anybody give me suggestion on this ..?

i tried google but no luck.

thanks

senthil

2

To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags

```text
 and 
```

by hand.)

Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums

3

Bumping up posts or double posting is not permitted in these forums.

Please read the rules, which you agreed to when you registered, if you have not already done so.

You may receive an infraction for this. If so, don't worry, just try to follow the rules more carefully. The infraction will expire in the near future

Thank You.

The UNIX and Linux Forums.