Oracle Stored procedure

[Anonymous]

Hi All,

Please help me in executing stored procedure which is in oracle db and need to pass multiple parameter value.

Thks in advance

[Anonymous]

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