Code completion for :new and :old does not work

[Gustavo]

Hi,

I've seen this problem before, and I think I've read other threads on this subject, with a "we'll check it" response. Maybe I deserve a patch for finding the bug?

If the ON clause includes only table name, everything is fine. But if you declare ON .

, the code completion will return the objects owned by , instead of the columns for

.

In our environment, triggers are NEVER owned by the table owner, so this is so not working... A minor patch on this would really come in handy.

Regards,
Gustavo

 

[Marco Kalter]

We'll fix it.

 

[Gustavo]

Hi, Marco!

Will this fix be in V9? In Oracle eBusiness Suite environments the trigger owner is always the same, which is never the table owner. Looking forward to this one.

Regards,
Gustavo

 

[Marco Kalter]

Yes, this is fixed for 9.0.

 

[Gustavo]

Thx a lot!

 

[Gustavo]

It works like a charm. Thx!