search_source
Search source code of Oracle Fusion objects for a keyword. Filter by type (procedure, function, package, etc.) and owner for faster scans.
Instructions
Full-text search across ALL_SOURCE in Fusion to find procedures/packages/functions that reference a keyword in their source code.
type_filter: PROCEDURE | FUNCTION | PACKAGE | PACKAGE BODY | TRIGGER Returns distinct owner/name/type — call read_object_source to get the full source.
Note: scans can be slow on large schemas; constrain type_filter and owner where possible.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| keyword | Yes | ||
| name_filter | No | ||
| type_filter | No | ||
| owner | No | ||
| limit | No |