Oracle Forms (MOSC)

MOSC Banner

Set Property Item Dynamically

I have  the following code in which is called in POST_QUERY trigger.

SET_BLOCK_PROPERTY( 'MY_BLOCK', INSERT_ALLOWED, PROPERTY_FALSE );
SET_BLOCK_PROPERTY( 'MY_BLOCK', UPDATE_ALLOWED, PROPERTY_FALSE );
SET_BLOCK_PROPERTY( 'MY_BLOCK', DELETE_ALLOWED, PROPERTY_FALSE );

The above does what I intend to do.

I have an item in MY_BLOCK which I would like to set true for insert, update and delete the above code.

I have tried as

SET_ITEM_PROPERTY('MY_ITEM',INSERT_ALLOWED,PROPERTY_FALSE);

However it didn't work the way I expected. How can I achieve this?

Regards

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