I have a trigger on a table with an XMLType column (in this case MSG_XML).
The trigger is to fire on the insert or update of the xml data.
It was created as
…
BEFORE INSERT OR UPDATE OF MSG_XML
…
When RE, TDM shows
…
BEFORE INSERT OR UPDATE OF MSG_XML,SYS_NC00002$
…
This gives an error when running the creation script as SYS_NC00002$ is unknown.
The TDM code is a correct representation of the data in ALL_TRIGGER_COLS,
however the pseudo coloumn added by Oracle should not be part of the SQL statement to create the trigger.
the CR is fixed now. Please find attached two zip files (we don’t know if you are using the latest beta or latest full version, that’s why two files are attached).
To install the modifications, please locate folder with system packages
(Default path: C:\Program files\Quest Software\Toad Data Modeler 3\Packages\System) and make a backup of this folder. Then extract files from zip archive and copy extracted *.txg files to the folder.
the CR is fixed now. Please find attached two zip files (we don’t know if you are using the latest beta or latest full version, that’s why two files are attached).
To install the modifications, please locate folder with system packages
(Default path: C:\Program files\Quest Software\Toad Data Modeler 3\Packages\System) and make a backup of this folder. Then extract files from zip archive and copy extracted *.txg files to the folder.