How to develop a VDB with Teiid Designer to execute a "Oracle stored package" from JBoss DV client

Solution Verified - Updated -

Issue

How to develop a VDB with Teiid Designer to execute a "Oracle stored package" from JBoss DV client
This is the DDL for the "Oracle stored package"

CREATE OR REPLACE PACKAGE pkg_test AS
PROCEDURE f_con (
str1 IN VARCHAR,
str2 IN VARCHAR
);
END;
CREATE OR REPLACE PACKAGE BODY pkg_test AS
var VARCHAR2(50);
PROCEDURE f_con(str1 IN VARCHAR, str2 IN VARCHAR)
IS
BEGIN
var := str1 || str2;
END f_con;
END pkg_test;
ALTER PACKAGE pkg_test COMPILE PACKAGE;
ALTER PACKAGE pkg_test COMPILE BODY;

User can confirm it using sqlplus, but need to know how to call thourhg VDB

select * from user_objects where object_type in ('PROCEDURE','FUNCTION','PACKAGE','PACKAGEBODY','TRIGGER');
call pkg_test.f_con('hello', 'world');

Environment

  • Red Hat JBoss Data Virtualization
    • 6.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content