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