Get all procedures defined in package
get
/database/objects/packages/procedures/
Returns all records from DBA_PROCEDURES or ALL_PROCEDURES view depending on role at runtime. Records included in the response are where OBJECT_TYPE = 'PACKAGE' and PROCEDURE_NAME is not null. A client requires SQL Administrator or SQL Developer role to invoke this service.
Request
Query Parameters
-
limit(optional):
The maximum number of records to return.
-
q(optional):
Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.
Response
200 Response
Describes all procedures that are defined in a package.