topic Re: call oracle function in qlikview in QlikView

call oracle function in qlikview

Mon, 04 Jul 2016 11:16:03 GMT

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

Re: call oracle function in qlikview

Peter_Cammaert — Mon, 04 Jul 2016 11:56:42 GMT

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

Peter

Re: call oracle function in qlikview

Mon, 04 Jul 2016 12:01:41 GMT

can you show me how?

i do this but script go to error

SQL

SELECT

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

FROM dual;

Re: call oracle function in qlikview

Peter_Cammaert — Mon, 04 Jul 2016 12:45:13 GMT

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

Re: call oracle function in qlikview

Mon, 04 Jul 2016 12:48:26 GMT

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