More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Oracle APEX Review: Security, SQL and Dynamic Actions

    1

    Reviews and designs Oracle APEX apps: SQL injection and XSS, authorization schemes, session state protection, query performance, dynamic actions, REST data sources and deployment, with fixes.

    $12

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Oracle APEX Review: Security, SQL and Dynamic Actions

    Oracle APEX Review: Security, SQL and Dynamic Actions

    Example session with this skill installed

    My APEX orders page has a classic report whose SQL concatenates :P5_SEARCH into the query string, and the Delete button is only hidden for non-admins. Review it.

    • Read your context and instructions
    • Compiled the oracle apex review

    Summary: high risk. Top issues: 1) SQL built by concatenating an item, 2) delete protected only by hiding the button, 3) session state protection unclear.

    CRITICAL Orders report - concatenated :P5_SEARCH - injectable - use a bind variable in the region source
    CRITICAL Delete process - no authorization scheme - anyone can call it - add an authorization scheme to the button and the process
    IMPORTANT Page 5 - session state protection - enable and set item protection

    Corrected SQL
    select order_id, status from orders where customer_name like '%' || :P5_SEARCH || '%'

    How to verify: call the page URL as a non-admin and try the process.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Helps APEX developers and students build secure, fast and maintainable apps. Reply in the language the user writes in; use APEX terms (application, page, region, item, dynamic action, process, validation, branch, shared component, authorization scheme, list of values, interactive grid, REST data source, session state).

    Ask or infer: APEX version, database version, what the app does, number of users and rows, authentication scheme, and the symptom or goal. You cannot open the builder: ask for exported page SQL, region source, process code, item settings and screenshots, with data removed.

    Use references/apex-checklist.md:

    • SQL injection: use bind variables for item values in region sources and processes; avoid building SQL strings by concatenating items; review dynamic SQL and function-body returning SQL.
    • Cross-site scripting: output escaping on items and report columns, careful use of HTML expressions and substitution strings.
    • Authorization: authorization schemes on pages, regions, buttons, processes and REST endpoints, not only hidden buttons; check at the server side.
    • Session state protection: enabled for pages and items that accept parameters; checksums on links.
    • Authentication, session timeout, and public pages.
    • Sensitive data: logs, debug mode in production, exposed emails or ids in URLs.

    Query efficiency (indexes, row limiting, pagination, avoiding functions on indexed columns), views for complex joins, PL/SQL packages instead of long anonymous blocks in pages, bulk operations, consistent transaction handling, and error handling that does not leak internals.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 6 days ago

    Permissions

    No special permissions declared or detected

    Listed6 days ago

    What's inside

    Frequently Asked Questions

    No. You paste exported page SQL, region and process code, item settings or screenshots with data removed.

    Yes where it relates to APEX apps: processes, packages, bulk operations and error handling.

    It says 'check in your APEX version' instead of guessing.

    No, it is a plain instruction skill that works with any AI agent.

    New in Data & Databases