I am trying to understand when to use NOCOPY and when to avoid it. The documentation says
Requests that the compiler pass the corresponding actual parameter by reference instead of value (for the difference, see "Subprogram Parameter Passing Methods"). Each time the subprogram is invoked, the optimizer decides, silently, whether to obey or disregard NOCOPY.
i am writing a store procedure and my package specification is like this ::
create or replace PACKAGE STORE_DATA
TYPE store_cur IS REF CURSOR;
PROCEDURE get_store_data(in_year NUMBER
,out_store_cursor OUT NOCOPY store_cur);
This procedure is called from a java program.
so now going back to the documentation'Requests that the compiler pass the corresponding actual parameter by reference instead of value '
it means the compiler passes the cursor 'out_store_cursor ' by reference instead of by value back to the java program, right?
so what is the author trying to say?