Re: New to DB Triggers..can U find the error?

From: Helmut Hahn <helmut.hahn_at_bitoek.uni-bayreuth.de>
Date: 1997/08/21
Message-ID: <01bcae11$dc7a9770$9f70b484@bti5d59e>#1/1

Hallo,

At least one problem is the use of the sequnces. They can't be used so simply. Try

DECLARE
        Id Number(10);
Begin

	select seq_address_id.nextval into Number from dual;
	insert into address

values(Number,:new.zip_book,:new.room,NULL,NULL,:new.stree,...) End

Also mit Currval. Hope this helps. I struggled some days with this, but now runs fine! And you are right no reference or anything else says something about this!

Helmut Received on Thu Aug 21 1997 - 00:00:00 CDT