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!

FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled except ORA-06508

600447Sep 25 2010 — edited Nov 3 2010
Dear Colleague,

I am migrating a Forms application from Forms 9i to Forms 10g. Most of my forms were originally created using the Oracle Designer Forms generator. I am also using the Webutil plugin. I just finished configuring Webutil, tested it and it seems to be working fine.

I am able to compile all code and generate a Form executable. However at runtime, I get an error as soon as the first line of code in the WHEN-NEW-FORM-INSTANCE trigger.

The error is:

FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06508

and the beginning of the code is as follows. Using the debugger, I found out that the line:

CGBS2$.SET_COORD_STYLE( 'P' );

initiates an error.

/* CGLY$INIT_CANVASES */
/* Call procedure to ensure correct canvases are visible */
BEGIN
CGBS2$.SET_COORD_STYLE( 'P' );
CGBS2$.SET_QRY_ON_ENTRY( 'Y' );
CGBS2$.SET_NAV_FROM_BLOCK( 'PROJ_BLOCK' );
CGLY$CANVAS_MANAGEMENT;
END;

Is the error telling me that this procedure was not found? How can I proceed to find the cause and solution of my problem? Are one of the Oracle Designer Forms Generator libraries missing?

I would appreciate a tip to help me begin seeing the light at the end of the tunnel.

Thanks and regards,

Randy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2010
Added on Sep 25 2010
8 comments
3,465 views