Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Forms 12.2.1: Error 801 unexpected fragile external reference

StauderOct 26 2015 — edited Oct 28 2015

Hi!

Trying around a bit the new forms builder 12.2.1 on Windows against a 12.1.0.1.0 Database, I stumbled over the following issue when creating and compiling a package body:

package declaration:

package globals is cursor get_emp isselect last_namefrom hr.employeeswhere employee_id = 205; emp get_emp%rowtype;end;

and the package body:

package body globals isbeginopen  get_emp;fetch get_emp into emp;close get_emp;end;

When compiling the body, the internal error 801 is raised: [unexpected fragile external reference]

Trying the same with a cursor like

  select user from dual

is compiled successfully.

Any ideas?

Thanks in advance and regards

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 25 2015
Added on Oct 26 2015
10 comments
1,516 views