1 Reply Latest reply on May 3, 2019 9:41 PM by Mike Kutz

    Ajax call returned server error ORA-20987 , HELP PLEASE!

    3991355

      Good afternoon, I am a beginner in oracle apex, I created an interactive grid using select in several tables making join between them, I would like to change data in the grid, however when entering a data and saving this error appears on the screen. How can I solve this?

       

      Error :

      • Ajax call returned server error ORA-20987: APEX - Process 'Horas - Save Interactive Grid Data' raised 'ORA-01733: virtual column not allowed here' while executing a DML command. This error can occur if a column is based on an aggregation or SQL expression. Set column attribute 'Query Only' to Yes to exclude the column from the INSERT and UPDATE statement. - Contact your application administrator. for .
        • 1. Re: Ajax call returned server error ORA-20987 , HELP PLEASE!
          Mike Kutz

          Please change your name

          Here is a quick video of how to change your display name.

          Change Name

           

          Need a Demo

          Please make a simple application that demonstrates this problem on http://apex.oracle.com

           

          You'll need to supply us

          • workspace name
          • application name/number
          • developer account's name
          • developer account's password

           

          Make sure that you create a Developer's account so you do not have to tell the SPAM BOTS what your email address is.

           

          DB Problem

          You can't modify Virtual Columns.

           

          You need to make sure APEX isn't trying to modify the columns automatically.

          Start by modifying the IG so that all of the Virtual Columns are READ ONLY.

           

          My $0.02

           

          MK