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.
Issue/Introduction
How can I invoke an Oracle-packaged procedure from within the TIBCO Data Virtualization server?