Re: store results from function into two seperate variables???

>> select p_storedivreg_hist.results(32) into x,y from dual;

SQL> var my_id number

SQL> select 1 into :my_id from dual;

         1

         1

SQL> print my_id;

     MY_ID

>> is there a way to store the results into two seperate varaibles?

SQL> VAR V_DBDIV NUMBER;
SQL> VAR v_DBREG NUMBER;

SQL> declare
  2 ref_c p_storedivreg_hist.resultset;   3 begin

  4     ref_c := p_storedivreg_hist.results(32);
  5     fetch ref_c into :v_DBDIV,:v_DBREG;

Procedimiento PL/SQL terminado correctamente.

SQL> print v_DBDIV;

v_DBDIV