Deprecated: Joomla\Input\Input implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /homepages/13/d380392445/htdocs/Jlive/libraries/vendor/joomla/input/src/Input.php on line 41

Deprecated: Return type of Joomla\Input\Input::count() should either be compatible with Countable::count(): int, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /homepages/13/d380392445/htdocs/Jlive/libraries/vendor/joomla/input/src/Input.php on line 170
Oracle Based Software

Macrotone Consulting in addition to writing bespoke Oracle packages and procedures, prepares generic code that is available upon request. Some of the code may have specific database version dependencies.

Auditing Package

This package supports both database trigger auditing and Fine Grain auditing, and provides a simple interface to implement these features upon database schema‚Äôs. Tested and developed on Oracle 9.x and Oracle 10.x.

Data Scrambling Package

This package enables sensitive data to be removed from a client site (subject to client agreement) by masking the identified table data columns with random data of the same data length and type. This preserves the data characteristics but ensures no real data information can be seen.  Any foreign key constraints dependant upon the masked columns would be disabled. Tested and developed on Oracle 9.x and Oracle 10.x.

Holidays Package

This package determines the number of working days between two specified dates. It can automatically calculates the Bank Holidays that occur within the specified period and subtracts them from the total available. It correctly allows for the different parts of the UK such as Ireland, Wales and Scotland, which have different holidays. The Bank Holiday determination is optional, otherwise it only allows for Saturday and Sunday being non-working days. Optional also is whether the start date is also included in the calculation.  Tested on Oracle 9i, 10g and 11g.

Go To Top

Joomla! Debug Console


Profile Information

Memory Usage

Database Queries