Calling oracle function which returns output from qlikview
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