Can We replace the pl/sql packages by qlikview scripts?

[#1]

Hi,

Can we replace the pl/sql packages using qlik view scripts? And is there any alternative method to associate the pl/sql packages directly to the qlikview and executing.

If any solution is there can you please reply on this.

Thanks,

UDAY VENKATESH

+91-9480025115

[danielrozental · Accepted solution]

Check this thread

http://community.qlik.com/forums/p/19638/74936.aspx

[#3]

Hi,

Any One can please reply on this......

Thanks,

UDAY V

[#4]

Hi,

PROCEDURE Prc_XYZ_Report( Id IN Number, Src_Type IN Varchar2, Region IN Varchar2, Product IN Varchar2, p_RunDate IN Date, p_RefCur OUT REF_Cur, p_Err_Code OUT Number, p_Err_Mesg OUT Varchar2 )

for above kind of procedure how can i call in qlik view and pass the parameters??

Can you please reply for this.

And adding (mode is write) can you give me syntax

Thanks,

UDAY V

[#5]

Can you please reply on this.

Thanks,

UDAY V

[suniljain]

Dear Uday,

You can call Stored Procedure from Qlikview Script Editor. Its execution is too slow. I will suggest you to implement sames logic in qlikview its faster than to call Stored Procedure from Qlikview

[#7]

Hi Sunil,

And one of the disadvantage i find in this is actually the package will be having some 10 to 15 tabels and each table is having nearly 2 to 3 lakh records then the reload will take lot of time.

Is there any easy method to load the data fast? Can you please on this..

[suniljain]

Dear Uday,

I am working on more than 35 crores of data in single table and in the initial day I strugges lots .

According to My experience . Incorporate business process in Qlikview Itself other than Pl/SQL.

Speed of processing of qlikview is very very fast.it also good in maintanance.

[#9]

Hi Sunil,

Suppose i reloaded the table once and later i need to add one more table at that time i need to load the data only for that table how can i do it?

Because once i give reload then it start loading the data for previous table also is there any solution can you please on this?

Thanks,

UDAY V

[suniljain]

Dear Uday,

Normally we extract full data one times and add subsequent increamental data in that QVD. so qliview's job become simple in increamental load.

Regards;

Sunil Jain