Oracle Apex Server Side Condition Type SQL

Question

I'm trying to set a server-side condition to an item. I want to check if the user's input is excisting in the database.

The sql query:

SELECT KAART_CODE FROM CADEAUKAART WHERE KAART_CODE = :P10_KAART_CODE

It gives me an ORA-06550: line 1 column 30: ORA-00936: missing expression error.

The query seems fine, i have no idea what i'm doing wrong here.

Hope this screenshot makes more sense:

user_4346500 · Answer

Use "Rows returned" condition instead.

When in doubt about what goes into any of the atrribute values, click on the "Help" tab. There's usually an example.