query_fusion
Run read-only SELECT queries against Oracle Fusion and receive results as XML. Use filters and column aliases to control output size and formatting.
Instructions
Run a read-only SELECT against Oracle Fusion and return the rows as XML.
Args: sql: A single SELECT statement. No trailing semicolon. Add WHERE/ROWNUM to keep the result small — BIP serializes the whole set. columns: Output column aliases in SELECT order, upper-case identifiers. Alias every column in the SQL to a simple upper-case name. fusion_user: Fusion user to run as (default bip_user).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"sql": "<sql>",
"columns": "<columns>"
},
"name": "query_fusion"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| columns | Yes | ||
| fusion_user | No | bip_user |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |