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

       

      DB: 11.2.0.4

      SQLcl: 19.4.0.3

      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
      
      
      SQL>                 
      

       

       

      Thanks ...