Oracle Forms (MOSC)

MOSC Banner

Compile Issue when db packages contain procedure parameters defined as a cursor%rowtype.

edited Sep 4, 2017 5:01AM in Oracle Forms (MOSC) 2 commentsAnswered

Oracle Forms 12c - Compile Issue db packages containg procedure parameters defined as a cursor%rowtype.

During compilation of forms, we run into a rather specific problem.

Situation

db 12c 

forms 12.2.1.2

compilation envirionment linux (redhat 7.3)

The db contains a package which is called from a form.

Typically, the db package contains definitions of procedures of which the parameters with the construct cursor%rowtype.

Program units at forms level which are calling the db package do not compile mentioning that the referenced db package does not exist.

Typically output in the .err file:

Compiling package body PackageNameInForms...

Compilation error on package body PackageNameinForms:

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