Free PL/SQL Utilities and Shareware

The following utilities are now available from the PL/SQL Pipeline - a free interactive community for Oracle developers. http://www.revealnet.com/plsql-pipeline/index.htm

Oracle PL/SQL Programming Companion Software By Steven Feuerstein, Bill Pribyl, and Fred Polizo

This zip file contains all of the files referenced in the 2nd edition of Oracle PL/SQL Programming by Steven Feurerstein and Bill Pribyl. This file also contains the Shareware version of Arjy (the Record Group Debugger for Oracle Forms, from ArtForms) and XRay Vision (a debugger for SQL*Forms that lets you view and modify the variables in your programs) that was not able to be included on the book's diskette. Format: pkzipped file, 505K.

Program Recompilation Utility
By Steven Feuerstein

This procedure will sweep through the ALL_OBJECTS catalogue for any INVALID stored programs and use the DBMS_DDL.ALTER_COMPILE built-in to recompile that program. It makes sure that package specifications are compiled before their package bodies -- and it only recompiles specs when explicitly needed.
Format: plain text file, 1K.

Bit and Random Number Manipulation Utility Package By Kevin Taufner

This package is earmarked by the RAND and BITWISE algorithms. The RAND algorithm fills the need within the Oracle 7.3 and earlier environment for a pseudo random number generator. The word 'pseudo' is emphasized here due to the fact that the RAND function will at some point produce a cyclic set of values. The BITWISE function adds the ability to manipulate numerical values by their binary digits. This means that a value of any number, can be modified on a bit level basis. This is useful for establishing bit-masks, bit-wise flags, and complex mathematical manipulations using binary arithmetic. The documentation is meant to provide a user or programmer with the essential information needed to integrate and utilize the PL/SQL source code located within. Enclosed with the documentation are examples and diagrams to assist in the understanding and use of the source.

Format: Word doc, 48K; plain text file, 14K.

Happy Holidays!

Cam White
RevealNet, Inc.
(202) 234-8557 Received on Tue Dec 23 1997 - 00:00:00 CST