Re: NULLS with ORACLE

From: Marty Himmelstein <marty.himmelstein_at_valley.net>
Date: 1995/08/03
Message-ID: <3vp7t9$o2v_at_dartvax.dartmouth.edu>#1/1


Anthony,

As an alternative to the trigger solution offered by several people, you could call a stored procedure from PowerBuilder instead of directly doing an Insert.Within the stored proc you can force the columns to a default value that is specified in the stored proc, and still maintain the not null constraint. Oracle procs let you pass a variable number of arguments. The stored proc is similar to a trigger, but you entirely control when it runs. It doesn't cause any side effects, and you don't have to worry about somebody else disabling it, or interacting with other triggers. Less overhead, too.

I've used this technique a lot with PB.

Marty Himmelstein
marty.himmelstein_at_valley.net Received on Thu Aug 03 1995 - 00:00:00 CEST

Original text of this message