topic Re: Call Oracle Procedure ? in QlikView

Call Oracle Procedure ?

Tue, 01 Dec 2009 19:58:14 GMT

Hi All,

Qlikview can call Oracle procedure ?

I ever call oracle function already, but i want to call procedure.

Thanks,

Call Oracle Procedure ?

Tue, 01 Dec 2009 22:20:04 GMT

have done in sql using sql execute

must be possible for oracle also

regards

peter

Call Oracle Procedure ?

Wed, 02 Dec 2009 09:16:54 GMT

Hi all,

Thanks for your response and how about that command ?,

thank you again

regards,

Call Oracle Procedure ?

Anonymous — Wed, 02 Dec 2009 09:27:03 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.

Re: Call Oracle Procedure ?

Fri, 21 Dec 2012 05:51:41 GMT

hi johannes

How can i call a oracle procedure with 2 input parameters and 2 output parameters????

it will be a great help if you can give a step by step syntax????

Thanks