T Mishra wrote:2. mismatching package name. Not sure which of the two are correct - XXCU_PKG or apps.XXCU_RETURN_PKG
I don't think so. Firstly, apps.XXCU_RETURN_PKG.get_return is a perfectly valid name (apps is probably a schema name, XXCU_RETURN_PKG is a package name and get_return is the procedure or function name). Secondly if the package name was not correct, it would produce a different error.
3. if it doesn't work try calling without package name
Calling a package procedure without specifying the package name will fail.
I suppose the get_return is a function, in which case it is needed to call it like this:and register the first parameter as an OUT parameter. I also assume the return type is a ref cursor, but I don't have experience with handling ref cursors in Java, so cannot help here
(That is, register the second parameter as an OUT parameter using CallableStatement.registerOutParameter and then retrieve the value by calling CallableStatement.getBlob(int parameterIndex). Obtaining parameters that are not cursors does not involve ResultSets.)
subject: How to call oracle procedure and fetch returned data using Java?