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

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

Thu, 10 Feb 2011 17:20:01 GMT

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

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

danielrozental — Fri, 11 Feb 2011 01:36:04 GMT

Check this thread

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

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

Fri, 11 Feb 2011 16:02:43 GMT

Hi,

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

Thanks,

UDAY V

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

Fri, 11 Feb 2011 16:41:47 GMT

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

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

Mon, 14 Feb 2011 05:21:38 GMT

Can you please reply on this.

Thanks,

UDAY V

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

suniljain — Mon, 14 Feb 2011 06:31:17 GMT

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

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

Mon, 14 Feb 2011 10:01:39 GMT

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

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

suniljain — Mon, 14 Feb 2011 10:17:28 GMT

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.

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

Mon, 14 Feb 2011 12:25:00 GMT

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

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

suniljain — Mon, 14 Feb 2011 12:41:07 GMT

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

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

Mon, 14 Feb 2011 12:52:05 GMT

Hi Sunil,

Can you please brief about the qvd how i can create once i load the data.

And you are telling that if any additional data needs to be added once after the load no need of reloading instead i can copy the extra data to the qvd ryt?

Thanks,

Uday V

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

suniljain — Mon, 14 Feb 2011 13:05:27 GMT

yea, Everytime you need not to extract full data. you have to just append new data and update existing data in QVD.

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

Thu, 08 Aug 2013 19:08:14 GMT

this link is dead

can you give me another link, please?