Can you rename the table and use a synonym?=20 -Daniel --=20 Daniel Harron Database Management IPsoft, Inc. daniel.harron@xxxxxxxxxxx http://www.ip-soft.net/ Phone: 888.IPSOFT8 Fax: 801.681.7664 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jacques Kilchoer Sent: Monday, April 26, 2004 6:24 PM To: Oracle-L (E-mail) Subject: any ideas for a workaround for bug 272219 (create trigger = error?) See Bug 272219 (Oracle 7.3 to 10.1 and all versions in-between), and Metalink forum discussion 149572.999. You cannot create a trigger on a table if the table has a column named = the same as the column's data type. =20 e.g. I cannot create a trigger on this table because the column name is = the same name as the column type =20 SQL> create table t ("DATE" date) ; Table cr=E9=E9e. SQL> create trigger tr before update on t 2 for each row 3 begin 4 null ; 5 end ; create trigger tr before update on t * ERREUR =E0 la ligne 1 : ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-320: the declaration of the type of this expression is incomplete or malformed =20 but I am able to create a trigger on this table (column name is not the = same as the column datatype) =20 SQL> create table t ("DATE" number) ; Table cr=E9=E9e. SQL> create trigger tr before update on t 2 for each row 3 begin 4 null ; 5 end ; 6 / D=E9clencheur cr=E9=E9. =20 Any ideas for a clever work-around? I can't change the column name = because the table was created by a third-party ERP application. =20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------