APEX

Hello,

I'm trying to get a javascript alert to pop up when the user enters a person's name that already exists in the persons table.

I wrote a plsql function that returns the names of people already in the table (names that match the name the user entered) and I need to get the result of this function in a javascript alert.

I don't want to use validations because I'd like the alert to appear immediately after the user updated the name field.

I also want the message to be just a notification for the user and let the user decide if he wants to insert the same person multiple times.
I tried to do this with dynamic action that executes plsql code but with no success.

Any ideas on how to do this?

Thanks, Adrian