Skip to main content
Glama

apex_add_item_computation

Add a computation to assign a value to an Oracle APEX item via static, SQL, PL/SQL, item copy, or sequence, with configurable timing and optional condition.

Instructions

Add a computation to set an item's value (STATIC, SQL, PL/SQL, ITEM).

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
page_idYesPage ID.
sequenceNoComputation order (for multiple computations on same item).
item_nameYesItem to compute (e.g., "P10_USER"). Auto-prefixed if needed.
condition_itemNoOnly compute if this item is not null (optional).
computation_typeNoHow to compute the value: - "static_value": A literal string value - "plsql_expression": PL/SQL expression (e.g., ":APP_USER || '@company.com'") - "plsql_function": PL/SQL function body returning the value - "query": SQL query returning a single value (e.g., "SELECT name FROM users WHERE id = :P10_ID") - "item_value": Copy value from another item (set item name in computation_expression) - "sequence": Get next value from a DB sequencestatic_value
computation_pointNoWhen to compute: - "BEFORE_HEADER": Before page renders (default) — good for initialization - "AFTER_SUBMIT": After form submit — good for post-processing - "BEFORE_BOX_BODY": Before page body rendersBEFORE_HEADER
computation_expressionNoThe expression/value/SQL for the computation type.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

The description only states the action ('Add') without revealing side effects, ordering implications, or reversibility. Annotations indicate readOnly=false and idempotent=false, but the description adds no further behavioral context such as whether repeated calls create duplicates.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is one sentence and front-loaded with the main action. However, the parenthetical list is cryptic and could be expanded or removed, though it does not add unnecessary length.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

While the schema and output schema are rich, the description is quite minimal for a complex tool with multiple computation types and execution timing options. The schema covers parameter semantics, but the description does not provide high-level guidance on how computations fit into page processing.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema provides thorough descriptions for all 7 parameters, including the distinct computation types and execution points. The description does not add parameter details, but the baseline is satisfied by the high schema coverage.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's function as adding a computation to set an item's value, which distinguishes it from related tools like apex_add_item or apex_add_process. The parenthetical mention of computation types ('STATIC, SQL, PL/SQL, ITEM') provides a useful overview, though it is somewhat abbreviated.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No explicit guidance is given about when to use this tool versus alternatives. The description does not mention common use cases, prerequisites, or why one would choose a computation over other mechanisms.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/TechFernandesLTDA/apex-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server