I seem to be stuck. Basically what I want to do is call a stored function or procedure that has one input variable and one output/return variable. The latter is a string which basically gives a status of the task performed. The function/procedure can look like this:

FUNCTION DO_STUFF ( IN_NUMBER IN NUMBER ) RETURN VARCHAR2 IS

PROCEDURE DO_STUFF ( IN_NUMBER IN NUMBER, OUT_STRING OUT VARCHAR2 ) IS

I have one "method" which I have tried calling as both a function and a procedure, but I struggle getting the return string. I have looked at the namedQuery-mapping way of doing it, but it only seems to allow return values that are either a mapped class or columns. Mine is just a string I make up as I go.

Any advice on how to achieve this?

I found out how to do this, by the way, but the connection() method is deprecated, so it is not the ideal solution. Here it is with the procedure version of the method: