Re: NEWBIE: Autonumber trigger

Do you have an example? I am new to the whole PL/SQL thing.

On Tue, 25 May 1999 17:09:05 +0200, "Fred Ruffet" <fruffet_at_kaptech.com> wrote:

>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 - 16:09:19 CDT