Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 
Connected as system@ORCL

SQL> create synonym head_sq for head_sq@RUSS;

Synonym created


SQL> select head_sq.nextval from dual;

   NEXTVAL
----------
   5795926

SQL> drop procedure test;

Procedure dropped


SQL> 
SQL> create procedure test is
  2    v_head_id number;
  3  begin
  4    select head_sq.nextval into v_head_id from dual;
  5    dbms_output.put_line('NEW ID:' || v_head_id);
  6  end;
  7  /

Procedure created


SQL> set SERVEROUTPUT ON
SQL> exec test;

NEW ID:5795928

PL/SQL procedure successfully completed


SQL> 

Connected to Oracle Database 11g Express Edition Release 11.2.0.2.0 
Connected as system@RUSTEST

SQL> create synonym head_sq for head_sq@RUSS;

Synonym created


SQL> select head_sq.nextval from dual;

   NEXTVAL
----------
   5795929

SQL> 
SQL> create procedure test is
  2    v_head_id number;
  3  begin
  4    select head_sq.nextval into v_head_id from dual;
  5    dbms_output.put_line('NEW ID:' || v_head_id);
  6  end;
  7  /

Warning: Procedure created with compilation errors


SQL> show errors;
Errors for PROCEDURE SYSTEM.TEST:
LINE/COL ERROR
-------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0/0      ORA-04052: error occurred when looking up remote object BIG3.HEAD_SQ@RUSS  ORA-00604: error occurred at recursive SQL level 1  ORA-06544: PL/SQL: internal error, arguments: [55916], [], [], [], [], [], [], []  ORA-06553: PLS-801: internal error [55916]  ORA-  

SQL>