Get a procedure that is defined in package

get

/database/objects/packages/procedures/{object_id},{subprogram_id}

Returns the corresponding record 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

Supported Media Types
Path Parameters
Back to Top

Response

Supported Media Types

200 Response

Information on the specified procedure.
Body ()
Root Schema : DatabaseObjectsProceduresItem
Type: object
Describes a procedure available in the database, along with associated properties. The list of attributes may vary depending on database version.
Show Source
Nested Schema : LinkRelation
Type: object
Show Source
Back to Top