search_objects
Search Oracle Fusion/ERP Cloud database objects by matching object name. Apply optional filters for object types, owner, and result limit to discover tables, views, procedures, and functions.
Instructions
Search ALL_OBJECTS in Oracle Fusion / ERP Cloud by object name pattern.
keyword: substring to match against object_name (case-insensitive) object_types: optional filter, e.g. ['TABLE','VIEW','PROCEDURE','FUNCTION','PACKAGE'] owner: optional schema owner filter (e.g. 'FUSION') limit: max results (capped at 200)
Returns: owner, object_name, object_type, status, last_ddl_time, table_comment
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| keyword | Yes | ||
| object_types | No | ||
| owner | No | ||
| limit | No |