6 Replies Latest reply: Nov 16, 2010 1:27 PM by sect55 RSS

    ORA-44003: invalid SQL name on INSERT

    sect55
      I have a form that contains 4 fields (1 hidden field - iD which is the primary key, select list - department, a text field -reporting year, and a shuttle field - employees. The user selects the department, change the date, then selects the employees from the department. When the submit button is pressed, a row should be inserted if ID is null. I get a ORA-44003: invalid SQL name while it attempts to insert a row. Can someone help please?

      It is on APEX.ORACLE.COM:
      Workspace: RGWORK
      Application: Financial Disclosure (30986)
      Page: 15
      User: TESTER
      Password: test123

      Make sure you choose TECHNOLOGY SERVICES DEPAR for Department.

      Robert
      http://apexjscss.blogspot.com
        • 1. Re: ORA-44003: invalid SQL name on INSERT
          20020
          Hi Robert,

          There is currently no FD_EMPLOYEES_SELECTED table (or updateable view) in your RGTEST schema. Was it perhaps dropped after the page was created?

          Hope this helps,
          John

          If you find this information useful, please remember to mark the post "helpful" or "correct" so that others may benefit as well.
          • 2. Re: ORA-44003: invalid SQL name on INSERT
            sect55
            John,

            I did forget to create the table in APEX.ORACLE.COM. But even after I did create it, I still get the same error.

            Robert
            http:/apexjscss.blogspot.com
            • 3. Re: ORA-44003: invalid SQL name on INSERT
              20020
              Hi Robert,

              There were a few issues in there:

              P15_ID was specified as a database column but without a source (I put in ID)
              P15_DEPT - same issue (I put in DEPT)
              P15_EMPLOYEES - was specified as a database column with a source of EMPLOYEES_SELECTED (I corrected it to EMPLOYEE_NUMBERS)

              It looks like it's working now.

              Hope this helps,
              John

              If you find this information useful, please remember to mark the post "helpful" or "correct" so that others may benefit as well.
              • 4. Re: ORA-44003: invalid SQL name on INSERT
                le
                Hi ,

                I couldn't reproduce this problem , the only problem that I noticed is error:
                ORA-20505: Error in DML: p_rowid=2, p_alt_rowid=ID, p_rowid2=, p_alt_rowid2=. ORA-01407: cannot update ("RGTEST"."FD_EMPLOYEES_SELECTED"."EMPLOYEE_NUMBERS") to NULL
                
                     Error      ORA-20505: Error in DML: p_rowid=2, p_alt_rowid=ID, p_rowid2=, p_alt_rowid2=. ORA-01407: cannot update ("RGTEST"."FD_EMPLOYEES_SELECTED"."EMPLOYEE_NUMBERS") to NULL
                     When I unselected all users in shuttle item.

                It happens because EMPLOYEE_NUMBERS is not nullable column.

                Regards,
                Lev
                • 5. Re: ORA-44003: invalid SQL name on INSERT
                  sect55
                  John,

                  Thanks a lot!! Once I entered the source, it worked!! I have to remember to check the source as well as the type.

                  Thanks again,
                  Robert
                  http://apexjscss.blogspot.com
                  • 6. Re: ORA-44003: invalid SQL name on INSERT
                    sect55
                    Lev,

                    I had planned to create a validation so this won't happen.

                    Robert
                    http://apexjscss.blogspot.com