skills.rest
kirivandubai
kirivandubaiCOMMUNITY
Explore all skills by this author →
GitHub

procedures

Creates, calls, and verifies Denodo 9.5 stored procedures using VQL templates.

Updated Sep 4, 2026
Search Tags:#stored procedures#vql#cursors#denodo#virtual dataport#java procedure#data virtualization
One-click install
npx skills add https://github.com/kirivandubai/denodo_wipe_coading_skills --skill procedures-kirivandubai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: procedures
Source: https://github.com/kirivandubai/denodo_wipe_coading_skills/tree/main/skills/procedures
Command: npx skills add https://github.com/kirivandubai/denodo_wipe_coading_skills --skill procedures-kirivandubai

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Working with Denodo 9.5 stored procedures means navigating three different kinds — predefined, VQL, and Java — each with its own syntax, parameter conventions, and failure modes, and the documentation rarely explains which one a task needs or why a call fails. ## Core Features & Use Cases - Predefined procedure calls: Call any of the 128 server-shipped procedures (GET_VIEWS, USED_BY, GENERATE_STATS) with input parameters passed in the WHERE clause, plus guidance on reading signatures via DESC PROCEDURE. - VQL procedure authoring: Write procedural logic with CREATE OR REPLACE VQL PROCEDURE — variables, IF/CASE/LOOP, cursors, exceptions, and EXECUTE of DDL — with verified templates and the exact placement rules for FOLDER and AS blocks. - Java procedure registration: Register a compiled class from an imported JAR with CREATE PROCEDURE ... CLASSNAME ... JARS. - Use Case: You need to loop over rows and create views dynamically. The Skill provides a verified VQL procedure template with a cursor, explains that FOR loop bounds must be literals, and ends with a live call to prove the body works. ## Quick Start Ask the agent to write a Denodo VQL stored procedure that takes an order amount and returns a size band, then apply and verify it on the dev server.

Frequently Asked Questions about procedures

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I call a Denodo predefined stored procedure?▼

Call a Denodo predefined procedure with SELECT ... FROM procedure_name() WHERE input_param = value, passing mandatory parameters in the WHERE clause named with the input_ prefix. The CALL statement is the positional alternative, but the SELECT form names parameters and can be joined with views.

How do I create a VQL stored procedure in Denodo 9.5?▼

Use CREATE OR REPLACE VQL PROCEDURE with FOLDER placed before the parameter list, local variables declared in an AS block, and the body in BEGIN ... END. Return results with RETURN ROW through OUT parameters, and note this requires the Enterprise or Enterprise Plus bundle.

Why does CREATE PROCEDURE fail with a syntax error near the parameter list?▼

The error occurs because CREATE PROCEDURE without the VQL keyword is the Java procedure statement, which has no parameter list or body. For procedural logic with variables and loops, write CREATE OR REPLACE VQL PROCEDURE instead.

Can a Denodo stored procedure run DDL statements?▼

Yes, a VQL procedure runs DDL through EXECUTE 'statement' with optional PARAMETERS placeholders for safe value substitution. The body binds late, so a statement naming a missing view is stored without error and fails only when the procedure is called.

What is the difference between VQL and Java stored procedures in Denodo?▼

VQL procedures are written in Denodo's procedural language with no compilation cycle, while Java procedures register a compiled class from a JAR imported into the server. Java is needed only for capabilities VQL lacks, such as calling external libraries.

Why does my Denodo procedure fail with a generic Error executing query message?▼

The generic error hides the real cause because procedure bodies bind at run time, not at creation. Wrap the body in EXCEPTION WHEN OTHERS (e) and return e.error_message to surface the actual failure, such as a missing view referenced by EXECUTE.

Related Skills

Explore More Data & Analytics Skills→
accelerate-dataaccelerate-data
3

listing-objects

List catalog objects and return structured JSON with references and definitions.

Official
Intermediate
likweitanlikweitan
49

cds-view-entities

Define ABAP CDS view entities with v2 syntax for RAP and analytics.

Community
Advanced
awfixers-stuffawfixers-stuff

zmx

Manage long-lived dev processes with consistent session prefixes and lifecycle controls.

Official
Intermediate
naviktnavikt
1

database

Manage Postgres JDBC in Kotlin with Migrator, DAO, and transactions.

Official
Advanced