Hi,
I try to create a temp table in a trigger:
CREATE TRIGGER TR_INSUPD_ATZ_WB FOR DBA.T_ATZ_WB 
AFTER INSERT, UPDATE EXECUTE (
    CREATE TABLE TEMP.ATZ_VIEW (
     BEGINN DATE, 
     ENDE DATE, 
     BESETZTE_STD FIXED(5,2), 
     FREIE_STD FIXED(5,2),
     MODELL CHAR(2));
)
 
But get the message:
Base table or view already exists;-6000 POS(104) Duplicate table name:ATZ_VIEW

In the archive I found this
http://lists.mysql.com/maxdb/21377
and expected that i can use temp tables in a trigger ?
 
Elke

Reply via email to