Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> problem with a trigger

problem with a trigger

From: <schatzle_at_my-dejanews.com>
Date: Thu, 10 Sep 1998 12:08:28 GMT
Message-ID: <6t8ffs$j8f$1@nnrp1.dejanews.com>


Hi,

i have a problem with a trigger.
I have created the following after insert trigger:

    create trigger .......
    begin

    create table SML ( SML_Ident NUMBER NOT NULL );

    end;

the compilation went right, but when i insert a row into the table, the trigger is on, then i get an error -204098 while executing this trigger.

I think, that the trigger was not successfully compiled, but i don't get any error.

any ideas?

thomas

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 10 1998 - 07:08:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US