call oracle function in qlikview

[#1]

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

[Peter_Cammaert]

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

Peter

[#3]

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;

[Peter_Cammaert]

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

[#5]

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