I have a form that shows one database record.
To choose which record I want to see, I have drop down box which returns the primary key.
The items in the form are populated by a standard Automated Row Fetch.
Everything works fine, even if I replace the table by a view on that table or replace it by a local view on a view in a different schema. (I do this by changing the 'table name' in the ARF process.)
When I define a synonym on the table or view I receive
ORA-06550: line 1, column 17: PL/SQL: ORA-00936: missing expression ORA-06550: line 1, column 9: PL/SQL: SQL Statement ignored
- which is a complete mystery to me.
Does anyone have a hint for me?
Many thanks in advance,
If you'd like to see the effect (login: demo/demo):