Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORDS_METADATA.ords_export.export_module ORA-20850

Mohammad ShaddadMay 20 2020 — edited May 20 2020

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

Comments

Processing

Post Details

Added on May 20 2020
0 comments
329 views