To validate a parameter value at runtime:
In the Object Navigator, expand the Data Model node, then the System Parameters or User Parameters node.
Double-click
(the PL/SQL icon) for the parameter for which you want to add a PL/SQL validation
trigger.
In the PL/SQL Editor, define the PL/SQL to be triggered at runtime.
Using a pre-defined system parameter
Copyright © 1984, 2005, Oracle. All rights reserved.