I try to call a procedure with an input parameter, at the base of hana it brings me the data but when calling them in the query manager I do not get anything This is my from my query manager
/ * Select * from "@ A1A_HSPC" t0 where t0. "U_codpro" like '% [% 0]%'; * / call "SAP_BELATRIX". "Test_Report02" ('[% 0]');
This is the procedure in hana
ALTER PROCEDURE "SAP_BELATRIX"."Reporte_Prueba02"(in periodo varchar(20)) LANGUAGE SQLSCRIPT AS BEGIN SELECT TOP 1 (SELECT COUNT(DISTINCT concat("U_codpro", "U_codemp")) FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'REG')), (SELECT COUNT(DISTINCT concat("U_codpro", "U_codemp")) FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'LBS')), (SELECT COUNT(DISTINCT concat("U_codpro", "U_codemp")) FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'PRA')), (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'REG' AND "U_codcon" IN ('LIQUIDO','DESADE'))), (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'PRA' AND "U_codcon" IN ('LIQUIDO','DESADE'))), (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'LBS' AND "U_codcon" IN ('LIQUIDO','DESADE'))), (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE "U_codcon" IN ('AFPFON','AFPPRI','AFPCOM') AND (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA'))), (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE "U_codcon" IN ('SNP','IMPUESTO','ESSALUDV','ESSALUD') AND (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA'))) - (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE "U_codcon" IN ('DEV5TAA') AND (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA'))), ((SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE ("U_codpro"
= :Periodo || 'REG' AND "U_codcon" IN ('LIQUIDO','DESADE'))) + (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'PRA' AND "U_codcon" IN ('LIQUIDO','DESADE'))) + (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'LBS' AND "U_codcon" IN ('LIQUIDO','DESADE')))), (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA')) AND "U_seg8" = 'H') + (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE "U_codcon" IN ('ESSALUD') AND (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro"
= :Periodo || 'PRA'))), (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE "U_codcon" IN ('VACPROV','GRAPROV','BOGRAPRO','CTSPROV') AND (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA'))) + (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA')) AND "U_seg8" = 'H') + (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE "U_codcon" IN ('ESSALUD') AND (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA'))) FROM "@A1A_HSPC" a WHERE ("U_codpro" LIKE '' || :Periodo || '%'); END;
If you bring me data
I put it that way because the period can be 201807EMP, 201807LBS and 201807PRA
Thanks