whenever sqlerror exit SQL.SQLCODEUnsupported Command
create or replace package TEST1
is
procedure test_procedure;
end TEST1; Package created.
create or replace package body TEST1
is
procedure test_procedure
as
begin
for i in (
select 1 as N
from foo
)
loop
DBMS_OUTPUT.put_line (i.N);
end loop i;
end;
end TEST1; Errors: PACKAGE BODY TEST1 Line/Col: 9/9 PL/SQL: SQL Statement ignored Line/Col: 10/14 PL/SQL: ORA-00942: table or view does not exist Line/Col: 13/9 PL/SQL: Statement ignored Line/Col: 13/31 PLS-00364: loop index variable 'I' use is invalidMore Details: https://docs.oracle.com/error-help/db/ora-24344
create or replace view TEST_VIEW as
select 1 as N from dualView created.
create or replace view TEST_VIEW2 as
select 1 as N from fooORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
create or replace view TEST_VIEW3 as
select 2 as N from dualView created.