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 <table_name>(NNI,TECH_MARKER,CURRENT_FIELD_BUILD_ID,DEFAULT_FIELD_BUILD_ID,CURRENT_EMNAME,DEFAULT_EM NAME,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 <table_name>(NNI,TECH_MARKER,CURRENT_FIELD_BUILD_ID,DEFAULT_FIELD_BUILD_ID,CURRENT_EMNAME,DEFAULT_EM NAME,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

Please post what Operating System and version you have and what Shell you are running. Please also mention what database engine and version you have.

If you get an error message, please post the whole error message. The message you post is an extract of the full error message (which would mention the name of the shell).

Assuming that the script is called makePhDN , please post the output from the following command which is designed to make control characters visible. The normal unix end-of-line will show as $ .

sed -n l makePhDN

and loose any empty line in your sql query

Please also avoid double posting. It just causes confusion and reduces your chances of getting an answer.