get_procedure_signature
Get the argument list of a stored procedure or function, including name, data type, direction, and defaults. Enables discovery without execution.
Instructions
Return the full argument list for a stored procedure or function (from ALL_ARGUMENTS). Returns: argument_name, data_type, in_out, position, defaulted, default_value
Note: Fusion MCP does not support dynamic procedure execution (BIP only runs SELECT data models). This tool is for discovery and understanding only.
package_name: required when the procedure lives inside a package.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| owner | Yes | ||
| object_name | Yes | ||
| package_name | No |