SQL>
SQL> select count(*) from dba_users;
1 row selected.
SQL>
SQL> create or replace procedure GET_ROW is
2 x number;
3 begin
4 execute immediate 'select 1 from dba_users where rownum = 1' into x;
5 end;
6 /
Procedure created.
SQL> create or replace procedure GET_ROW authid current_user is
2 x number;
3 begin
4 execute immediate 'select 1 from dba_users where rownum = 1' into x;
5 end;
6 /
Procedure created.
SQL>