needing help from the PL/SQL experts

From: <burwelm_at_my-dejanews.com>
Date: Tue, 06 Oct 1998 20:53:10 GMT
Message-ID: <6vdvvm$pjs$1_at_nnrp1.dejanews.com>

[Quoted] [Quoted] OK... So I have a database trigger that needs to assign values to some columns. But only when the transaction statement is not assigning them. Specifically..

date_created, created_by, date_modified, modified_by

When the sql statement does not include these columns, my trigger needs to assign sysdate and user, but if the sql statement does include them then the [Quoted] trigger should do nothing.

My trigger logic for all columns is modeled as follows:   if :new.date_created is null then
    :new.date_created := sysdate;
  end if;

The problem is that it is trully testing for the VALUE NULL rather then whether the sql statement includes that column. And it does not execute the [Quoted] logic appropriately.

Any help out there from the PL/SQL experts.

Melissa

[Quoted] -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Oct 06 1998 - 22:53:10 CEST