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.

    ApexBine
      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,
      Sabine


      If you'd like to see the effect (login: demo/demo):
      Table:
      [http://apex.oracle.com/pls/otn/f?p=17361:3|http://apex.oracle.com/pls/otn/f?p=17361:3]
      Synonym:
      [http://apex.oracle.com/pls/otn/f?p=17361:4|http://apex.oracle.com/pls/otn/f?p=17361:4]