In Oracle, you can call a stored function with a syntax like:
var result number
exec :result := pkg_ims_status.ext_checkdbstatus()
The function will return a value to be stored in the variable result.
You can call the same function in QlikView using an ordinary SQL SELECT-statement like:
SQL SELECT
pkg_ims_status.ext_checkdbstatus() as status;
Running a stored procedure without returning any recordset:
Use the function CALL to specify the name of the stored procedure.
Example (Launches XYZ with the two parameters 2 & 5):
sql call XYZ ( 2 , 5 );
This works for both ODBC and OLE DB. However, when opening the connection using OLE DB, make sure to add (mode is write) before the finishing semi colon in the connection string.
