FAQ
Can you rename the table and use a synonym?=20

-Daniel

--=20
Daniel Harron
Database Management
IPsoft, Inc.
daniel.harron_at_ip-soft.net
http://www.ip-soft.net/
Phone: 888.IPSOFT8
Fax: 801.681.7664
-----Original Message-----
From: oracle-l-bounce_at_freelists.org =

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_at_freelists.org put
'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedApr 26, '04 at 5:20p
activeApr 26, '04 at 5:25p
posts3
users2
websiteoracle.com

2 users in discussion

Daniel Harron: 2 posts Jacques Kilchoer: 1 post

People

Translate

site design / logo © 2022 Grokbase