Best way to update large field

From: James Williams <techsup_at_mindspring.com>
Date: Wed, 23 May 2001 17:56:57 GMT
Message-ID: <3b0bf935.110601234@news.mindspring.com>

Get the dread ora_00972 trying to do the below. I can insert the row but would like to update an existing row. Any good id

        SQL> @order
ERROR:
ORA-00972: identifier is too long

SQL> edit order
No lines in the buffer
"order.sql" 3 lines, 331 characters

     1  UPDATE control
     2  SET ENTITY_LIST_SQL = "select (entity_key) from it_order where

to_date(
due_dte, 'YYYYMMDD' ) < (sysdate - entity_criteria) and cmpl_stat_cd NOT LIKE '
%' and cmpl_stat_cd IS NOT NULL and it_order.cis_ordr_nbr in (select cis_ordr_n
br from upl_detail_at_purge38) order by (entity_key)"

     3 WHERE ENTITY = 'ORDER'
~

SQL> show user
USER is "XXX"
SQL> desc control;

 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 ENTITY                                    NOT NULL VARCHAR2(30)
 PROCESS_TYPE                              NOT NULL VARCHAR2(1)
 ENTITY_CRITERIA                           NOT NULL VARCHAR2(30)
 COMMIT_COUNTER                            NOT NULL NUMBER(8)
 LUD_START                                          DATE
 LUD_STOP                                           DATE
 REVISION_CD                               NOT NULL VARCHAR2(1)
 LUD                                       NOT NULL DATE
 HISTORY_FLAG                                       VARCHAR2(1)
 ENTITY_LIST_SQL                                    VARCHAR2(500)
 DESCRIPTION                                        VARCHAR2(5

Received on Wed May 23 2001 - 12:56:57 CDT