Oracle Forms (MOSC)

MOSC Banner

Recompile required if calling DB package with user defined record type as out parameter

edited Oct 5, 2018 5:09AM in Oracle Forms (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center