How to run an oracle stored procedure in qliksense and get the returned value from the procedure

[julius75]

I have tried all the available ways of executing an oracle procedure that return one value but I have not succeeded.Kindly help out.

I have used the syntax below all in vein;Note 'parameter2' is the returned value

Sql {call PROC  'parameter2'}

Sql {call PROC ('parameter2')}

Sql {call PROC (parameter2)}

SQL {call PROC 'parameter2'}  !EXECUTE_NON_SELECT_QUERY

SQL exec PROC