Toad World® Forums

RE Oracle 9i


#1

When reverse engineering After Update Of trigger an extra comma(,) is being added.

The trigger is defined in Oracle as;
After Update Of Col1, col2

TDM is importing this as Update Column List;
,“Col1”,“Col2”

And the generated DDL becomes
After Update Of ,“Col1”,“col2”

The first comma(,) before the first column name goves rise to a syntax error.

Regards
Malcolm


#2

Hello Malcolm,

Doing our best, we’ve failed to simulate the problem. We’re sorry.
Could you please send us the SQL code of CREATE TRIGGER and a screenshot of the problem?

Thanks very much.

We look forward to your reply.

Regards,

Vladka + Mario


#3

Got it!
Malcolm, please ignore my previous post. We’ve just found the problem and will fix it. CR # 43 197.

Thanks!!

Regards,

Vladka