How to develop a VDB with Teiid Designer to execute a "Oracle stored package" from JBoss DV client
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.