topic Re: How to call Stored Procedure in Qlik replicate in Qlik Replicate

How to call Stored Procedure in Qlik replicate

JayLopez — Mon, 19 Feb 2024 09:26:26 GMT

We are having issues on loading some tables from source. As advised by DBA we should run this sp prior to pulling the table: exec session#.open_session. Problem is how we can achieve this in qlik replicate. Appreciate any feedback on this.

Re: How to call Stored Procedure in Qlik replicate

john_wang — Mon, 19 Feb 2024 09:30:57 GMT

Hello @JayLopez ,

Welcome to Qlik Community forum and thanks for reaching out here!

I'm not sure what's the source database type and the purpose of exec session#.open_session. any helpful information is welcome.

Thanks,

John.

Re: How to call Stored Procedure in Qlik replicate

JayLopez — Mon, 19 Feb 2024 10:51:19 GMT

Sorry I mistakenly click the button as accepted solution. But exec session#open.session is something that activates table that is inactive for a while

Re: How to call Stored Procedure in Qlik replicate

john_wang — Mon, 19 Feb 2024 11:37:01 GMT

Hello @JayLopez ,

No worries, I've removed the solution mark.

The execu session might be used to execute a specific procedure or function in your Oracle env however it's hard to add to Replicate connection.

Not sure if you can get the acrivates table by SQLPlus without "exec session". If yes, then Qlik Replicate may works as well.

Thanks,

John.