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 <=2323 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 |
|---|