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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

tip on "bogus" frm-42100

lakeJul 14 2007 — edited Jul 16 2007
I've had this happen to me a couple times. As soon as a form
starts if you have an on error trigger that does display_error, you
get frm-42100. So it appears like a bogus error, as if the on-error trigger
were fired when there was no error. If you try to avoid displaying the
error_code 42100 that doesn't work either. In my case I found that
what actually happened was there was an error in the when-new-forms-instance
trigger. This occurred because some code in there tried to set an
item that was query only before enter-query mode. I think that the error code
is apparently lost before the on-error trigger fires. Or something. Anyway
I thought I'd mention it that if someone was plagued by this check out the
form level triggers.

Personally I am really having problems with things like this. As another example:
"FRM-30113: Block must have non-query-only database item. Cause:  A block that allows updating and inserting must have at least one item derived from the database. Action:  Create a derived item in the block."

What on earth does that mean? What is a "derived item"? I had huge problems
with this error and the actual cause was in the block the dml data target type
was set (by default by forms). Apparently that isn't acceptable with a query only block. What I'm wondering is if there is a third party
tool that makes forms development easier?

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 13 2007
Added on Jul 14 2007
9 comments
8,314 views