SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 31 17:28:05 2016

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> var c refcursor;
SQL> create procedure testp(o_p out number) as
  2  begin o_p := dbms_random.value; end;
  3  ;

Procedure created.

SQL> sho err
No Errors.

SQL> begin open :c for
  2    'with function wrapper_f(x in number) return number
  3      is l_v number;
  4      begin testp(l_v); return l_v; end;
  5    select rownum r, wrapper_f(1) r2 from dual';
  6  end;
  7  /

PL/SQL procedure successfully completed.

SQL> print c;
         R         R2
---------- ----------
         1 .376033788

SQL>