Re: Required field for updates

From: Walt <walt_at_boatnerd.com.invalid>
Date: Fri, 25 Jul 2003 12:11:07 -0400
Message-ID: <3F21569B.C680F6B7_at_boatnerd.com.invalid>


LKBrwn_DBA wrote:
>
> Try:
>
> IF Updating('APPLICATION_ID') Then
> .. Do something ...
> Else
> raise_application_error(-200001,'No APPLICATION_ID found');
> End If;

Thanks. That appears to do it. I've used the IF UPDATING construct before, but I didn't know you could specify a column. Cool.

You wouldn't happen to have a pointer to some documentation to this feature, would you? It's not covered in any of my Oracle Press or O'reilly PL/SQL books.

-- 
//-Walt
//
//
Received on Fri Jul 25 2003 - 18:11:07 CEST

Original text of this message