How to execute an Oracle Report - Qlik Community

Anonymous · ‎2016-12-12

Hi!

How can I execute the following code into QlikView Script?

DECLARE

ERRBUF VARCHAR2(200);

RETCODE NUMBER;

P_DATE_INI VARCHAR2(200);

P_DATE_FIN VARCHAR2(200);

P_PROVIDER VARCHAR2(200);

P_SUC_PROVIDER VARCHAR2(200);

P_ART VARCHAR2(200);

P_ACCOUNT VARCHAR2(200);

P_APROB VARCHAR2(200);

P_OUTPUT VARCHAR2(200);

BEGIN

P_DATE_INI := '2016/09/01';

P_DATE_FIN := '2016/09/30';

P_PROVIDER := NULL;

P_SUC_PROVIDER := NULL;

P_ART := NULL;

P_ACCOUNT := NULL;

P_APROB := NULL;

P_OUTPUT := 'Archivo';-- Contantes 'Archivo'

--

EXECUTE IMMEDIATE 'alter session set nls_language= ''Latin American Spanish''';

--

bolinf.CSX_XXXXX_XXXXX(

ERRBUF => ERRBUF,

RETCODE => RETCODE,

P_DATE_INI => P_DATE_INI,

P_DATE_FIN => P_DATE_FIN,

P_PROVIDER => P_PROVIDER,

P_SUC_PROVIDER => P_SUC_PROVIDER,

P_ART => P_ART,

P_ACCOUNT => P_ACCOUNT,

P_APROB => P_APROB,

P_OUTPUT => P_OUTPUT

);

/* Legacy output: */

DBMS_OUTPUT.PUT_LINE('ERRBUF = ' || ERRBUF);

DBMS_OUTPUT.PUT_LINE('RETCODE = ' || RETCODE);

END;

I execute this code into SQL Developer and it works, what can I do to execute using QlikView?

marcus_sommer · ‎2016-12-13

I hope this will be helpful for you:

- Marcus