Larry Steinle

August 23, 2013

Programmatically Validating Oracle Packages

Filed under: Oracle — Larry Steinle @ 10:06 pm
Tags: , ,

Whenever an Oracle view, function, procedure or package header is modified the object is invalidated and any objects that call the invalidated object become invalid. To avoid errors these objects need to be compiled. The purpose of this article is to demonstrate how to identify the invalid objects compiling them in the correct order so that all objects can be validated in one pass while providing the ability to track which objects fail to validate.

(more…)

Advertisements

March 9, 2011

Argument Validation

Filed under: Security,VS.Net — Larry Steinle @ 9:07 pm
Tags: , , ,

I wanted to take a small break from the Active Directory Data Access Layer to discuss a best practice that should be considered when constructing a code library. The first priority when constructing a reusable code base is the class diagram. The structure of the classes and the names of the methods impact how easily a class library can be to implement. Equally important is the careful attention to detail for argument values.

(more…)

Blog at WordPress.com.