execute_query
Execute read-only SELECT or WITH queries against Oracle Fusion database via BI Publisher. Returns query results as columns and rows.
Instructions
Execute a read-only SELECT or WITH (CTE) query against the Oracle Fusion database via BI Publisher.
Only SELECT/WITH statements are accepted — DML, DDL, and PL/SQL are rejected. SQL is executed through the BIP SQL-runner report (deployed manually in the BIP catalog; see FUSION_REPORT_PATH).
sql: the full query text with literal values inlined (BIP does not support bind variables — include values directly, e.g. WHERE org_id = 101) max_rows: maximum rows to return (server cap also applies)
Returns: {columns: [...], rows: [{col: val, ...}, ...], count: N} Note: all values are returned as strings (CSV transport).
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| max_rows | No |