2 Replies Latest reply: Oct 9, 2009 2:57 AM by ApexBine RSS

    Automated Row Fetch on Table with Synonym causes ORA-00936: missing expr.

      Good morning!

      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):