Skip to content

Instantly share code, notes, and snippets.

@recursivecodes

recursivecodes/ords-enable-schema.sql

Created June 28, 2019 17:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save recursivecodes/72071c9bea5beae369b5987a18a4a526 to your computer and use it in GitHub Desktop.
Save recursivecodes/72071c9bea5beae369b5987a18a4a526 to your computer and use it in GitHub Desktop.
Download ZIP
ords-enable-schema.sql
Raw
ords-enable-schema.sql
BEGIN
 ords_admin.enable_schema(
  p_enabled => TRUE,
  p_schema => 'SCHEMA-NAME',
  p_url_mapping_type => 'BASE_PATH',
  p_url_mapping_pattern => 'schema-alias',
  p_auto_rest_auth => NULL
 );
 commit;
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment