0 Replies Latest reply on May 20, 2020 10:50 PM by Mohammad Shaddad

    ORDS_METADATA.ords_export.export_module ORA-20850

    Mohammad Shaddad

      Hi All

      Kindly, I was trying to export my ORDS web service DML, but I got the following error, I search in oracle community and I found it's bug and only it will work if I execute the command from SQLcl, but unfortunately, it does not work and returned the same error, please help




      ORDS: 19.2.0.r1991647


      SQL> SELECT ORDS_METADATA.ords_export.export_module(p_module_name=>'MYORDS') FROM dual;
      Error starting at line : 1 in command -
      SELECT ORDS_METADATA.ords_export.export_module(p_module_name=>'MYORDS') FROM dual
      Error report -
      ORA-20850: Parameter p_module_id must not be null.
      ORA-06512: at "ORDS_METADATA.ORDS_EXPORT", line 235
      ORA-06512: at "ORDS_METADATA.ORDS_EXPORT", line 534
      ORA-06512: at "ORDS_METADATA.ORDS_EXPORT", line 616



      Thanks ...