Jump to content
We've recently updated our Privacy Statement, available here ×

davidiazcasta

Members
  • Posts

    3
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Posts posted by davidiazcasta

  1. Hi everyone!

    You can call the procedure when you adding a dataset with  PL/SQL text code.

    { CALL schema.NAME_SP($P{param1} , $P{param2} ,$P{ORACLE_REF_CURSOR}) } [/code]

    the param Oracle_ref_cursor  contains the params of your response call, and you  must create the fields. the field name must be the same procedure to set your params return like that:

    <queryString language="plsql">            <![CDATA[{CALLschema.NAME_SP($P{param1} , $P{param2} ,$P{ORACLE_REF_CURSOR})]]>        </queryString>        <field name="response1" class="java.lang.String"/>        <field name="response2" class="java.lang.String"/>[/code]

       

    Now, you can use any ORACLE procedures.
     

×
×
  • Create New...