Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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