Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

call oracle function in qlikview

hi,

this is first that i try to call a oracle function in qlikview, can someone help me??

this is the function:

FUNCTION F_WAIT_GMBI_LOAD (P_SEC_WAIT INTEGER DEFAULT 10, P_NUM_WAIT INTEGER DEFAULT 100) RETURN NUMBER


the function return a 1 or 0


thx

4 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Create a SQL SELECT statement that calls this function to process some data (one row is ok) and return the value.

Peter

Not applicable
Author

can you show me how?

i do this but script go to error

SQLSELECT

F_WAIT_GMBI_LOAD (P_SEC_WAIT INTEGER DEFAULT 10, P_NUM_WAIT INTEGER DEFAULT 100)  as test

FROM dual;

Peter_Cammaert
Partner - Champion III
Partner - Champion III

May we know which error?

This doesn't look like a valid Oracle SQL statement to me. AFAIK you're using the function prototype in a function call which cannot be good... I'm not an Oracle expert, if you aren't either I guess you can find help in an Oracle forum.

Best,

Peter

Not applicable
Author

this is the error:

SQL##f - SqlState: S0022, ErrorCode: 904, ErrorMsg: [Oracle][ODBC][Ora]ORA-00904: "F_WAIT_GMBI_LOAD": invalid identifier

function:

SQL SELECT

(CASE WHEN F_WAIT_GMBI_LOAD (0, 1) < 0 then '0' else '1' END )  as test

FROM dual