Change parsing schema for APEX REST Service

Phil W

Hi,

Using APEX 5.1 and ORDS 18.2.

I am new to using REST, all looks great and easy to set up but where on earth can I change the parsing schema please? If I export, this is included in the script and seems to be the first APEX schema provisioned.

I have 60 apps and 50ish schemas so want this to be specific for a schema for different REST calls but this does not appear to be possible from the ORDS setup in APEX?

Many thanks

Phil

Phil W

This appears to be resolved with APEX 18.2 - allows us to select an associated workspace schema and install the restful ORDS objects on a schema by schema basis. The schema name can then be aliased to reference within the REST URL.

So it looks like we have to upgrade!

Pierre Yotti

Did you try to change the schema using something like this?

ORDS.ENABLE_SCHEMA(

      p_enabled             => TRUE,

      p_schema              => 'Your_schema',

      p_url_mapping_type    => 'BASE_PATH',

      p_url_mapping_pattern => 'api',

      p_auto_rest_auth      => FALSE);  

https://docs.oracle.com/cd/E56351_01/doc.30/e87809/ORDS-reference.htm#GUID-8A4C061C-8ED0-41F2-9F1B-9EC701C8F186

Phil W

This enables a schema. I can do this but the REST call definition uses the default schema (we think it is the first provisioned schema) which is shown when the export script is examined.

We want to create a number of REST services that use different schemas.

Phil W

This appears to be resolved with APEX 18.2 - allows us to select an associated workspace schema and install the restful ORDS objects on a schema by schema basis. The schema name can then be aliased to reference within the REST URL.

So it looks like we have to upgrade!