today:
63
yesterday:
158
Total:
1,001,317

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
126 ACTION admin 2019.01.11 6454
125 Fundamentals of PL/SQL admin 2016.05.10 2031
124 QR Code plugin admin 2017.11.30 1586
123 QR Code plugin Process admin 2017.11.30 963
122 How to Update Oracle XE Version admin 2018.02.23 930
121 GP PRINT admin 2018.05.31 918
120 INSTR admin 2016.05.19 785
119 SELECT last_name FROM admin 2018.12.12 742
118 TREE admin 2016.05.18 722
117 IMP admin 2018.10.08 717
116 JK admin 2019.02.05 700
115 CREATE TABLE admin 2018.09.25 471
114 APEX Password Change admin 2016.08.26 453
113 JavaScript for Member List admin 2016.08.17 428
112 Membership Management admin 2016.06.09 426
111 QRCODE admin 2020.05.25 405
110 control break admin 2016.06.25 389
109 SQL admin 2016.07.15 388
108 DATE Compare admin 2018.05.22 366
107 APEX Web Services Proxy Settings admin 2016.06.07 351