My Oracle Support Banner

Adding All Packages Procedure to PL/SQL Gateway (Doc ID 3063158.1)

Last updated on DECEMBER 12, 2024

Applies to:

Oracle REST Data Services - Version 24.2.3 and later
Autonomous Database Dedicated - Version NA and later
Information in this document applies to any platform.

Goal

You are migrating PLS to ORDS and has multiple packages and its proceudres which needs to use ords_admin.add_plsql_gateway_procedure to help add them to PL/SQL gateway.

Your statements are as

Procedure add_plsql_gateway_procedure takes one package and its one proceudre at a time. You are looking for some script to help generate code for all package and its all procedues of given SCHEMA.


 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.