nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calling stored procedure

KavithaDeepak

Hi All,
 
I need to call stored procedure from data set.I am calling like { call BIRT_REPORT_PROCEDURE(?)} 
 
i added Parameter but direction is coming as Input always.How to enable direction as Out Put or In out.
 
 
Thanks,
Kavitha

Find more posts tagged with

Comments

Clement Wong

The other option is that you can have BIRT compose the SQL statement with your parameters in the Query Text within theProperty Binding of the Edit Data Set dialog.
 
For example:
call BIRT_REPORT_PROCEDURE(params["yourParameter"].value)