You can use a cursor variable as a subprogram parameter, which makes it useful for passing query results between subprograms. For example:

You can open a cursor variable in one subprogram and process it in a different subprogram.

In a multilanguage application, a PL/SQL subprogram can use a cursor variable to return a result set to a subprogram written in a different language.

Note:
The invoking and invoked subprograms must be in the same database instance. You cannot pass or return cursor variables to subprograms invoked through database links.