How to execute an Oracle Report

Anonymous — Mon, 12 Dec 2016 21:41:58 GMT

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?

Re: How to execute an Oracle Report

marcus_sommer — Tue, 13 Dec 2016 08:21:27 GMT

I hope this will be helpful for you:

Re: Running a MSSQL Server stored procedure

Re: Fetching Oracle stored procedure data into QlikView FAILS

- Marcus

topic Re: How to execute an Oracle Report in QlikView

How to execute an Oracle Report

Re: How to execute an Oracle Report