[SQR Extension] Section

On Windows systems only, [SQR Extension] defines DLLs containing new user functions (ufunc) and user calls (ucall). Ufunc and ucall reside inside SQREXT.DLL and/or other DLLs.

When SQR.DLL and SQRT.DLL are loaded, they look for SQREXT.DLL in the same directory, and for any DLLs specified in [SQR Extension] such as:

[SQR Extension]
c:\sqrexts\sqrext1.dll=
c:\sqrexts\sqrext2.dll=
c:\sqrexts\sqrext3.dll=

Any new extension DLLs containing new user functions must be listed in [SQR Extension] in SQR.INI. For more information, see “Interoperability” in Volume 1 of the Hyperion SQR Production Reporting Developer's Guide.

For Windows/Oracle, Production Reporting uses dynamic binding of Oracle routines. When Production Reporting tries to access an Oracle database, it searches for the Oracle DLL as follows: