Hi Bruno, I don't know if this helps you. Change your trigger, so you only retrieve a new sequence number if the field is empty. Something like this:
CREATE OR REPLACE TRIGGER TRG_CARL_ID BEFORE INSERT ON CARLINES FOR EACH ROW BEGIN IF :new.carl_id IS NULL THEN SELECT seq_carl_id.nextval INTO :new.carl_id FROM dual; END IF; END; Best regards Tom Am Montag, 2. Juli 2012 19:53:19 UTC+2 schrieb Bruno Augusto: > > friends, > > I am using oracle database and when execute the save command the oracle > save and on the same time it run a currval sequence. The problem is I do > not need to use sequence in this table. > > Is there anyway from cake does not execute the sequence? > -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en.
