在表的定义中引用保留字引起的PLS-00222错误......
SQL> desc t1;
Name Null? Type
----------------------------------------- -------- ----------------------------
C1 DATE
SQL> select * from t1;
C1
--------
20070428
SQL> update t1 set c1=to_date('20070501','yyyymmdd');
1 row updated.
SQL> commit;
Commit complete.
SQL> create or replace procedure p_test1
2 is
3 begin
4 update t1
5 set c1 = to_date('20070428', 'YYYYMMDD');
6 end p_test1;
7 /
Procedure created.
SQL> desc tmr
Name Null? Type
----------------------------------------- -------- ----------------------------
FROM_DATE NOT NULL VARCHAR2(8)
TO_DATE NOT NULL VARCHAR2(8)
OBU NOT NULL VARCHAR2(4)
PART_NO NOT NULL VARCHAR2(12)
LPK NOT NULL VARCHAR2(3)
REGISTER_DATE