4 Replies Latest reply: Oct 5, 2010 6:09 AM by 766292 RSS

    Auto Row Fetch (After upgrade to 4.0.1)

    766292
      All,

      I have recently migrated an application from 3.2.0 to 4.0.1 and all seems fine apart from my Automatic row fetch processess on every page have stopped working. They have not been changed in anyway from old version to new.

      Fire: On Load After header
      Error: ORA-06550: line 1, column 17: PL/SQL: ORA-00936: missing expression ORA-06550: line 1, column 9: PL/SQL: SQL Statement ignored
      Unable to fetch row.

      The page loads first time but then when clicking an edit link for a report row I receive the above error.

      I have tried:
      1. Disabling the row fetch to make sure it is that failing
      2. Deleting it and recreating

      Any helps is greatly received.

      Regards
        • 1. Re: Auto Row Fetch (After upgrade to 4.0.1)
          Patrick Wolf-Oracle
          Hi Nick,

          you can run the Advisor (Application\Utilities\Advisor) for your application to see if it returns some errors for your application. That might help to track down this problem.

          Regards
          Patrick
          -----------
          My Blog: http://www.inside-oracle-apex.com
          APEX 4.0 Plug-Ins: http://apex.oracle.com/plugins
          Twitter: http://www.twitter.com/patrickwolf
          • 2. Re: Auto Row Fetch (After upgrade to 4.0.1)
            766292
            Hi Patrick,

            I have run the advisor and see no errors. Ther is one warning about a target item not existing on target page but this is believe is unrelated.

            Slight change of problem after some more investigation. Sorry I have mislead you.
            This problem is not realated to me updating to the new version as the problem actually existed on the app in the old version I just had not check throughly enough.

            I am trying to fetch data over a dblink and it appears that this is causing the issue. I moved the refrenced table to the local database and the fetch works.

            My question should have been:
            How can I fetch row data to the form over the dblink?

            Thanks for you response

            Nick
            • 3. Re: Auto Row Fetch (After upgrade to 4.0.1)
              Patrick Wolf-Oracle
              Hi Nick,

              if you want to use a remote object in a DML process (note: for reports that's not necessary) you have to create a view on the local database
              create or replace view my_view
              as
              select * from my_remote_object@remote_db;
              The reason is that APEX needs to find the referenced table of the DML process in the ALL_OBJECTS database dictionary view. But remote objects are not included, that's why you have to "wrap" them in your local database.

              Regards
              Patrick
              -----------
              My Blog: http://www.inside-oracle-apex.com
              APEX 4.0 Plug-Ins: http://apex.oracle.com/plugins
              Twitter: http://www.twitter.com/patrickwolf
              • 4. Re: Auto Row Fetch (After upgrade to 4.0.1)
                766292
                Patrick,

                ISSUED RESOLVED

                Thank you this is now working.
                As you mentioned I created a view and referenced this in the automatic row fetch instead.

                Thanks again

                Nick