Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Qlikview can call Oracle procedure ?
I ever call oracle function already, but i want to call procedure.
Thanks,
have done in sql using sql execute
must be possible for oracle also
regards
peter
Hi all,
Thanks for your response and how about that command ?,
thank you again
regards,
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.
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