Shell Programming and Scripting

I am using the following code to update a table of mine. The problem is that the long string created to tempfile5 gives me the SP2-0027 error in Oracle. Is there any way to break up my string and still preserve the integrity?

Code:

echo `awk -F "|" '{x=x","$1} END{print substr(x,2)}' $tempfile2` > $tempfile5
#echo "UPDATE $STAGINGDBSCHEMA.$TABLE L SET L.MSG_PROCESS_TS=TO_DATE($q$CURRDATETIME$q,$q"YYYY-MM-dd HH24:MI:SS"$q) WHERE L.MSG_ROW_SEQ in (`awk '{print $0}' $tempfile5`);" > $SEQSQL
#sqlplus -s <<EOF 
#set heading off
#set pagesize 0
#set tab off
#@$SEQSQL
#exit
#EOF

---------- Post updated at 10:42 PM ---------- Previous update was at 09:07 PM ----------

AHA

i just came up with a solution. I put the echo statement I used above inside the original do while loop and spooled that to .sql file. That way I had a complete update statement for each msg_row_seq. When I invoked that file in sqlplus, it ran very fast for 800+ records so think I will stick to that solution for now.

the first line can be changed .(I don't understand why you need echo it)

Code:

awk -F "|" '{printf $1 ","}' $tempfile2 > $tempfile5