Scriptoria generates Oracle procedures and global temporary table to implement variable column Crosstab queries. The procedure must first be called to populate the global temporary table with the results of the query. Scriptoria generates VBA functions that call the procedures.
The PUBLIC VBA functions are named by converting the QueryDef name to conform with VBA naming conventions. They can be called from anywhere VBA functions are permitted.