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?
