This content has been marked as final. Show 3 replies
Do you have specific reason to use this query source -I strongly suggest to redesign your form style such way that you can use view instead of query.
However please refer below link :
Check out your block columns match in name/type those of the dynamic select.
This error is commonly caused when you have items in your block that don't match the list of columns in your query. Either make these items "non-database" items or move them to a Control Block. If all of the items in your block match your query columns, then check the Block property Query Data Source Columns and make sure the columns in this property are correct and their data types.
It sounds like you are basing your block on a From Clause Query. If this is true, I recommend you look at the following: Oracle Forms From Clause Query
Hope this helps,