When I define the handler (in SQL Workshop) as
BEGIN
cin7trigger(:entity_type,:body);
END;
and create two IN parameters in the proc, and define entity_type as a parameter in ORDS, I get a 555 error. I am using postman, POST with a json body. Revion have upgraded to ORDS 25 but it did not fix the problem
The request could not be processed because an error occurred whilst attempting to evaluate a SQL statement associated with this resource. Verify that the URI and payload are correctly specified for the requested operation. If the issue persists then please contact the author of the resource. SQL Error Code: 6550, Error Message: ORA-06550: line 2, column 3: PLS-00306: wrong number or types of arguments in call to 'CIN7TRIGGER' ORA-06550: line 2, column 3: PL/SQL: Statement ignored https://docs.oracle.com/error-help/db/ora-06550/