Skip to Main Content
Forums

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!

how to create a trigger for Shift + A key press in oracle forms 12c

User_P0HY3Sep 3 2021

In oracle form builder, I want to use a trigger for Shift + A, (it just cant be any other key, dont ask me why please), but there are only a few specific KEY- triggers available. I just want to run some PL/SQL code whenever Shift + A is pressed in a form.

Im using oracle forms 12c.

Maybe I could use the trigger "when-custom-javascript-event" but I dont understand where to put the javascript code.

Help please. Thank you

Comments

Mike Kutz

TAG using JSON value might be more flexible.

This would then allow template based code generators (eg ) to automatically identify which tables need to be combined together to create a specific Transactional API (XAPI).  (eg an API that must work with >1 tables)

MK

1 person found this helpful
Jeffrey Kemp

Tags for table columns, constraints, etc. would also be useful.

1 person found this helpful
Matheus Boesing

TAG using JSON value might be more flexible.

This would then allow template based code generators (eg ) to automatically identify which tables need to be combined together to create a specific Transactional API (XAPI).  (eg an API that must work with >1 tables)

MK

Great Mike!
It really should be done with JSON syntax. It allows to create different kinds of tags in a single 'tag column', like:
[...]TAGS ('{Use:Transactional, SensitiveData:false, Version1.0:MatheusDBA, Version2.0:AnotherDBA}');


Or even tags hierarchies/subtypes... Anyway, it's way more flexible.
Thanks for this insight!

Matheus Boesing

Tags for table columns, constraints, etc. would also be useful.

Exactly... I just used some kind of objects for this example... but I believe it can apply for any king of object, including schemas... like (using Mike's contribution):
CREATE USER USER_EXAMPLE TAGS ('{Use:AdHocReports, Accountable:InternalBusinessTeam}');

Gbenga Ajakaye

This would definitely be useful.

1 - 5

Post Details

Added on Sep 3 2021
#12c, #forms, #moved-from-devops, #oracle, #sql-developer, #weblogic
7 comments
1,422 views