Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mfarslnn
Contributor
Contributor

Using Oracle User Defined Functions in SQL

Hello,

I have a PL/SQL query in which we have some user defined functions to check if value is true. Query working fine on DB. When I want to run the same query in data load editor it throws an error. 

Here is my simplified Qlik query:

load * ;
sql 
select 
rainbow.get_org110_nvalue_f('BYMN', '1018', 'GOUT') as x 
FROM dual;

 

And here is the error it gives:
ss.PNG

 

I've tried writing with single or double quotes but it didn't work. 

Thanks in advance,

Labels (2)
0 Replies