How to trigger PL/SQl Stored Procedures from Qlikview Application???

[#1]

Hi All,

My requirement is to trigger PL/SQL Stored Procedure on Oracle DB. On successful completion of this Stored Procedure I need to reload my Application. Please post your suggestions and approach for resolving this.

Thanks,

Nag

[jagan]

Hi Suresh,

Is  that Stored procedure working in Oracle?

What you are doing in the Stored Procedure?  Are you using select query?

Regards,

Jagan.

[sureshbaabu]

Jagan,

please find the comments below:

1)Yes, the stored procedure runs perfectly in oracle.

2) The Proc will just insert an entry to a table. I have granted permission to execute this PROC on different schema.

create or replace procedure Procname as

begin

insert into dummy values (1,’abc’);

commit;

end;

[#4]

Hi Nagendra,

Thank you for the discussion!!.

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

I have enabled all the settings in QlikView.

But 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 oracl...

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

Thanks a lot in advance.

Regards,

Laxmaiah Chowdary

[#5]

Hi Maxgro,

Thank you for the inputs!!.

Could you please help in integrating oracle stored procedure data with QlikView.

I have tried all the above changes.

But 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 oracl...

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

Thanks a lot in advance.

Regards,

Laxmaiah Chowdary

[Marcio_Campestrini]

Hi

Have you solved your problem? If you did, please choose the correct answer and help us to keep community focused.

[Anonymous]

If you have a PL/SQL stored procedure with a ref cursor out parameter you CANNOT call it directly from QlikView and get your ref cursor results as the input data for QlikView.

You CAN call a PL/SQL stored function with a return type of ref cursor. But you must call it through ODBC not OLEDB exactly as highlighted by Massimo Grossi above.

You could simply wrap your PL/SQL stored procedure in a PL/SQL function to achieve what you are looking for.

[Marcio_Campestrini]

Got you issue solved? Please mark helpful/correct answers.