Oracle Stored procedure

Anonymous — Thu, 22 Nov 2012 13:14:20 GMT

Hi All,

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

Thks in advance

Re: Oracle Stored procedure

Anonymous — Fri, 23 Nov 2012 01:52:41 GMT

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

topic Oracle Stored procedure in QlikView

Oracle Stored procedure

Re: Oracle Stored procedure