Toad World® Forums

Triggers and XMLType columns


#1

Hi,

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.

Kind reagrds
Malcolm


#2

Hi Malcolm,

thank you. We will look into the matter. We added this to our system under change request #71186.

Have a nice day,

Vaclav


#3

Hi Malcolm,

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.

Regards,

Vaclav
Beta 3.5.4.1 (3.5.3.1).zip (124 KB)


#4

Hi Malcolm,

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.

Regards,

Vaclav
Full (Patch) 3.4.16.7.zip (124 KB)


#5

Hi Vaclav

We are currently using 3.4.15.10 and Oracle 10g

Regards
Malcolm


#6

Attached one zip file for version 3.4.15.10.
Full 3.4.15.10.zip (98.8 KB)