How can I invoke an Oracle packaged procedure from within the TIBCO Data Virtualization server?
Article ID: KB0082823
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.0 and higher |
Description
This article discusses invoking an Oracle-packaged procedure from within the TIBCO Data Virtualization server.
Issue/Introduction
How can I invoke an Oracle-packaged procedure from within the TIBCO Data Virtualization server?
Resolution
You can use a Packaged Query to invoke an Oracle packaged procedure from within the CIS.
Here is an example of a Packaged Query that invokes DBMS_OUTPUT.PUT_LINE():
<version 2> multipartseparator=;+;
CALL DBMS_OUTPUT.PUT_LINE('hello'); ;
SELECT COUNT(*) from dual; ;
The first line specifies the separator for individual commands or queries. The list of commands must end with a query that returns a cursor, such as:
select current_date from _v_dual
or:
select count (*) from dual
Note
If you need to add an output parameter, go to the Parameters tab of the Packaged Query, highlight the result cursor, and then add an output parameter. e.g. schoolgrade type INTEGER.
Here is an example of a Packaged Query that invokes DBMS_OUTPUT.PUT_LINE():
<version 2> multipartseparator=;+;
CALL DBMS_OUTPUT.PUT_LINE('hello'); ;
SELECT COUNT(*) from dual; ;
The first line specifies the separator for individual commands or queries. The list of commands must end with a query that returns a cursor, such as:
select current_date from _v_dual
or:
select count (*) from dual
Note
If you need to add an output parameter, go to the Parameters tab of the Packaged Query, highlight the result cursor, and then add an output parameter. e.g. schoolgrade type INTEGER.
Feedback
Yes
No
Powered by
