Re: Triggers and Constraints

cmtnl_at_worldaccess.nl wrote:
>
> Who can tell me something about the working of triggers and constraints in an
> Oracle database. Especially in what why can I turn the triggers and constraints
> on and off.
>
> I want to fill an Oracle database by means of an ODBC-driver and a MSAccess
> interface ( self-made ). I am not able to make some updates in the database
> because it is prohibited by the constraints and triggers of the database. I am
> familiar with the data structure of the database, so I will not destroy the
> integrity of the database.
>
> P.P.J. Hensgens, The Netherlands

triggers are code that fire when operation happen on the table (insert,update,delete). Once they fire it executes pl/sql code. if something in that code says the data is wrong it generates an exception and kicks out the database operations.

constraints are validations enforced by the database. these are typically primary keys, foreign keys or specific values for a column.

you cannot change these from the outside and unless you can admin the database you are out of luck.

check with the designer what the constraints are and the rules of the triggers and either get them to change them or live with it.

Todd Verstraten
mailto:tverstrat_at_tier3.com
http://www.tier3.com Received on Fri Oct 18 1996 - 00:00:00 CEST