Calling oracle function which returns output from qlikview

sbasavar — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am new to qlikview and need help. I am trying to invoke oracle function which returns output as boolean. Ideally this function execute logic and insert data into table, based on output of this function I need to select data from other table.

I am unable to invoke function using statement SQL Select dboschema.pckgname.funcname ('a','b','c','d')as temptable from dual; in qlikview

When I try to execute above statement it gives me an error of invalid data type; all passed parameter are varchar in function.

When I execute function in DB with PLSQL synatx as above it gives me same error. Then I executed pckg in DB with syntax

declare

valu BOOLEAN;

begin

valu := dboschema.pckgname.funcname ('a','b','c','d')

if valu

then

dbms_output.put_line('True');

End if;

This worked for me in DB. I am looking for similar expression in Qlikview. Can anyone help me on this asap ?

Thanks & Regards,

Sangeeta

topic Calling oracle function which returns output from qlikview in QlikView

Calling oracle function which returns output from qlikview