get_procedure_source
Retrieve the source code of stored procedures, functions, packages, or triggers from an Oracle database. Specify the object name, type, and schema to get the exact DDL.
Instructions
Get the source code of a stored procedure, function, or package.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Name of the procedure/function/package | |
| type | No | Type of the object (default: PROCEDURE) | PROCEDURE |
| schema | No | Schema name (defaults to current user's schema) | |
| connection | Yes | Name of the database connection to use |