Hello Guys I am facing this weird error
procedure get_events(evts out resultset) as
begin
-- get all event records meet the schedule and data condition
open evts for
select /set fo coolumns*/
from abc_def.hello_tbnle ss
where /*conditions*/
order by /*conditions*/
end get_events;
I am getting the errors at the above blue lines saying:
Error: PL/SQL: SQL Statement ignored
Error: PL/SQL: ORA-00942: table or view does not exist
But the query is working if I run it out of the procedure.
And the table exits and I have grant select on that table.
Thanks