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.

FRM-93652 Error When Try To Query

Daniel NoroñaSep 22 2022

Hello
I'm migrating forms from version 11g to 12.2.1.2, and I'm getting an FRM-93652 error every time I try to run a query on the form,
Queries run fine when the exact value to search for is entered but fail when trying to enter %123% or a value that does not exist

Comments

Answer

Well, it's easier (one click less) than the code with grant option - permissions can be defined at object level and at user level and it's obvious if you look at dialogs:

permissions_with_grant.png

Philip

Marked as Answer by FC60 · Nov 28 2019
FC60

Merde Philip!!!

Before my eyes!

Sorry, I'm very stupid.

User_84SZK

Hello Philip,
is there a possibility to pull / synchronize these rights(WITH GRANT OPTION) from the database and not set it manually?
My usecase is.
I would like to generate the data modeler from the database and then generate the scripts from the data modeler and import this into another environment.

1 - 3

Post Details

Added on Sep 22 2022
9 comments
361 views