drop table A2_GUESTS 
                        ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
create table A2_GUESTS (id number)
                        Table created.
insert into A2_GUESTS select level from dual connect by level <=23
                        23 row(s) inserted.
create or replace package BEACHCOMBER is 
    v_Guest_Count pls_integer; 
    function get_cnt return number; 
end BEACHCOMBER; 
                        Package created.
create or replace package body BEACHCOMBER is 
    function get_cnt return number 
    is 
    begin 
        return v_Guest_Count; 
    end get_cnt; 
begin 
    select count(*)  
    into v_Guest_Count 
    from A2_GUESTS; 
end BEACHCOMBER; 
                        Package Body created.
begin 
    dbms_output.put_line('count = ' || BEACHCOMBER.v_Guest_Count); 
end; 
                        Statement processed.
count = 23
insert into A2_GUESTS values (42) 
                        1 row(s) inserted.
select BEACHCOMBER.get_cnt  
from dual 
                        | GET_CNT | 23 | 
|---|
alter package BEACHCOMBER compile body 
                        Package altered.
select BEACHCOMBER.get_cnt  
from dual 
                        | GET_CNT | 24 | 
|---|