Scriptoria for Oracle Client-Server Edition Only!
Scriptoria for Oracle includes a package that contains Oracle equivalents to most Access/VBA non-standard intrinsic functions. This VBA_FUNCTIONS package is installed on the Oracle server when Scriptoria encounters one of the functions during query conversion.
Pressing the Install button will first create a new owner/user using the name supplied in the Owner Name field, who will be granted CONNECT and RESOURCE privileges. If the owner/user and/or synonym exists, it will be dropped upon user approval.
The VBA_FUNCTIONS package is then deployed for the newly created user/owner. The user/owner grants EXECUTE privilege to public. A public synonym is also created using the name supplied in the Synonym field.