Japanese

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!

Insert-procedure trigger fires instead of update procedure in Oracle forms

User_L6UFCJun 9 2020 — edited Jun 17 2020

I have a form which is used to modify a column in a table. The record which is being updated is failing some validation, but in this form all those failures are overridden and the column will be updated. This works fine for majority of records. However for few records the commit is not happening. When debugged I found that for these problematic records INSERT-PROCEDURE trigger is fired where as for the successful records UPDATE-TRIGGER is fired which is correct. Can somebody tell why this is happening and how to solve this?

My form version is 12.2.1.3.0 and it is on Redhat Linux server.

Thanks

K Raghavendra Bhat

gernot

Instance debugging (d0.sql) shows that HTTP header variable is found and its value is correct. But the sentry function still fails - see attachment
d2.txt (12.99 KB)Which additional conditions are checked in the sentry function (in HTTP header variable authentication scheme to login in APEX itself)?
(user exists and is open)
Thanks

user12097829

Hi,
I've the same problem here (using Apex 21.2 and Apex 22.1):
HTTP header variable is set by Apache and found by Apex. But the sentry function still fails.
Using the Oracle provided "HTTP header variable" authentication scheme, there's no possibility to specify a custom sentry function, but obviously there must be an internal sentry function.
Which additional conditions are checked in the internal sentry function?
Thanks

user12097829

Hi,
found a solution for my problem with "HTTP header variable":
Following several tutorials I had set "Verify Username" to "After Login" for my authentication scheme.
After changing setting "Verify Username" from "After Login" to "Each Request" everything works fine.
Thanks

Japanese

Insert-procedure trigger fires instead of update procedure in Oracle forms

Comments

Post Details