Recompile required if calling DB package with user defined record type as out parameter
We call a function i a database package returning data to the form in an out parameter defined as a user defined record type.
This works well but the problem is the form has to be re-complied against each database, thus not making it possible to distribute the forms as a pre-compiled fmx.
If the variable declaration is done within the trigger (When-Validate-Item), no error is raise but the functions just isn't called.
If the call is moved to a forms package and the declaration is done in the form package an error "ora-06508 pl/sql could not find program unit being called" is raised.