Re: NEWBIE: Autonumber trigger

From: Fred Ruffet <fruffet_at_kaptech.com>
Date: Tue, 25 May 1999 17:09:05 +0200
Message-ID: <7ieeeo$5ff$1@gatekeeper.ornano.kapt.com>

I don't think trigger is the better way for two major reasons : 1. Oracle will refuse, when executing a trigger AFTER (or even BEFORE) INSERT, to make operations on your table (like for example counting the number of elements in the table).
2. The number you want to set in the trigger is the primary key, and you couldn't process the insert statement whithout having this value.

A better way would maybe to do the insert within a PL/SQL procedure, which one you would be passing as args the values of the field to insert.

David Rabsch a écrit dans le message <374ab0a1.4209402_at_news.mts.net>...
>Hi, real newbie here. I'm trying to create an application using MS
>Access 97 as a front end and Oracle 8 for Netware as the back end. I
>created the app entirely in Access, and now am migrating the data to
>Oracle. Does anyone have a simple trigger to emulate the AutoNumber
>function in Access? I'm VERY new to PL/SQL, but pretty seasoned in
>VB, and comfortable in SQL. Thx.
Received on Tue May 25 1999 - 10:09:05 CDT