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 ![WhatsApp Image 2023-07-01 at 13.16.49.jpeg WhatsApp Image 2023-07-01 at 13.16.49.jpeg](https://community.qlik.com/t5/image/serverpage/image-id/111430i38F6617D0E6822B2/image-size/large?v=v2&px=999)