describe_plsql
Retrieve arguments, data types, modes, positions, and full source code for Oracle PL/SQL procedures, functions, or packages. Read-only, no changes.
Instructions
Describe a PL/SQL object: returns its arguments (name, data type, in/out, position) and full source code. Read-only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Object name (procedure, function or package). | |
| type | No | Object type, e.g. 'PROCEDURE', 'FUNCTION', 'PACKAGE' or 'PACKAGE BODY'. | |
| schema | No | Schema (owner) of the object. Optional — defaults to the server's current schema; omit rather than guess. |