How To Prevent Insert

[AOT]

I'm an absolute Oracle novice but I'm designing a simple DB for Uni. I have a form which shows existing records on a single record basis. I've prevented insert at the data block level but included a 'New' button which changes the block's allow insert property and pre-defines a code into a read only field.

I have a post_block trigger which returns the allow insert to false for the block but I can't stop user's from navigating (arrow keys) to another new record once they've clicked the 'New' button. This causes my code to fail.

All I want to do is keep them on the current record until they click the 'Save' button.

Can anyone please help?

Regards AOT

 

[Mockenrue]

Why not define the block as Insertable ? Obviously insert is always allowed when
pressing the New button.

You can assign the pre-defined value in the When-Create-Record trigger.