today:
178
yesterday:
242
Total:
1,004,336

You could do a count(*) instead

declare
  l_cnt integer;
begin
  select count(*)
    into l_cnt
    from items
   where id_referencia = :P2_REFERENCIA;

  if( l_cnt >= 1 )
  then
    return true;
  else 
    return false;
  end if;
end;

If you really wanted to do an exists, you'd do something like this. I don't know why you'd want to do this assuming that id_referencia is the primary key of the table. But you could

declare
  l_exists integer;
begin
  begin
    select 1
      into l_exists
      from dual
     where exists( select 1
                     from items
                    where id_referencia = :P2_REFERENCIA );
  exception
    when no_data_found
    then
      l_exists := 0;
  end;

  if( l_exists = 1 )
  then 
    return true;
  else
    return false;
  end if;
end;
No. Subject Author Date Views
19 Validation to detect text in numeric field admin 2018.05.19 241
18 Assign a network host to Access Control List admin 2016.06.07 295
17 CAPTCHA PLUG-IN admin 2016.05.27 299
16 Oracle 11g Access Control List for External Network Services admin 2016.06.07 302
15 ACL 보기 admin 2016.06.07 309
14 CREATE_ACL (1st STEP) admin 2016.06.07 314
13 How to set a proxy in UTL_HTTP admin 2016.06.07 320
12 function get area admin 2016.06.08 324
11 Access Control List (ACL) admin 2016.06.07 343
10 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 343
9 ADD_PRIVILEGE (2nd STEP) admin 2016.06.07 348
8 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 354
7 APEX Web Services Proxy Settings admin 2016.06.07 359
6 control break admin 2016.06.25 398
5 Membership Management admin 2016.06.09 435
4 APEX Password Change admin 2016.08.26 461
3 JK admin 2019.02.05 702
2 IMP admin 2018.10.08 719
1 Fundamentals of PL/SQL admin 2016.05.10 2038