Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to execute an Oracle Report

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?

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary