I want to Alert when a duplicate TCKT_ID is entered. Specifically, I want to Alert on Loss of Focus.
I have a Dynamic Action with Event Lose Focus and DOM Object document.getElementsByName('TCKT_ID').
How do I reference the value entered so I can check whether it exists in the DB. I tried EXISTS
select 1 from BPS_TCKT where TCKT_ID = apex_application.g_f06(1)
But I get the error
Failed to parse SQL query! ORA-06553: PLS-221: 'G_F06' is not a procedure or is undefined
Note: I've used "apex_application.g_f06(1)" to get the value into a page item once the page is submitted.
So why does it work in one select but not in another? (See what works, below.)
Begin
select apex_application.g_f05(1) into :P63_SITE_CD FROM DUAL;
select apex_application.g_f06(1) into :P63_TCKT_ID FROM DUAL;
select apex_application.g_f07(1) into :P63_TCKT_STAT FROM DUAL;
select apex_application.g_f08(1) into :P63_TCKT_DSCRP_TX FROM DUAL;
End;
Thoughts,
Howard