topic Re: EXEC Oracle Stored Procedure !! in QlikView

EXEC Oracle Stored Procedure !!

Thu, 15 May 2014 11:43:45 GMT

Hello everyone;

I have a procudre ORACLE stored procudure with 2 inputs and one output to increment IDs and return the next ID from the DAtaBase.

I'm going to call this procedure from my QlikView script.

I tried this code , but does not works in my script:

SQL

EXEC Nom_PROC ('IN1','Y','OUT');

What are the steps to use this procedure? and what is the way maeilleur dy called from the script, or through a VB macro that executes from the dashboard?

thank you

Re: EXEC Oracle Stored Procedure !!

offjunior — Thu, 23 Apr 2015 16:45:19 GMT

Hello Friend!

About calling procedures from within QlikView, if you have not achieved, you can try the way that I will describe below.

Step 1:

Set your script editor and it will open the databases in read and write mode.

Step 2:

Correctly write your connection string, it is ODBC or OLEDB, add, before or after the password the following content

"Mode is write"

Step 3:

Write correctly the call of Procedure that you want to call, in my example will look like this ...

"SQL call user_bi.prc_custo_padrão_real('4.2014','007');"

I think this should work, I have helped.

Hug!

Re: EXEC Oracle Stored Procedure !!

Thu, 02 Jun 2016 14:02:45 GMT

Hi,

Thank you for the discussion!!.

I am facing issues in integrating oracle stored procedure data with QlikView.

I am not able to fetch Oracle stored procedure data into QlikView as well as insert records into Oracle table through stored procedure.

I have posted the issue in forum atQlikView integration with Oracle Stored procedure FAILS in fetching data and inserting data to oracle table

Could you please take a look at and advise for corrections.

Thanks a lot in advance.

Regards,

Laxmaiah Chowdary