16 Replies Latest reply: Oct 16, 2017 5:07 AM by Jonathan Dienst RSS

    Oracle Procedure

    Daniele Caprelli

      Hi i have this procedure in oracle in my schema:

      CREATE OR REPLACE PROCEDURE PROVADANO (prc out sys_refcursor) AS

      BEGIN

         open prc for

          SELECT *  FROM "ETRM_XXX"."V_XXX" aa

      END PROVADANO;

       

      how can i call this in qlikview?

       

      i tried with:

      SQL EXECUTE "MYSCHEMA"."PROVADANO";

      or SQL EXECUTE "PROVADANO";

      and with

      SQL CALL "MYSCHEMA"."PROVADANO";

      or

      SQL CALL "PROVADANO";

       

      but nothing it say not find the procedure, where i wrong?

      thanks