create table log_messages (
id number,
message clob,
create_dt timestamp default SYSTIMESTAMP)Table created.
create or replace package utils as
procedure do_some_action(p_id number);
end utils; Package created.
create or replace package body utils as
procedure save_log(
p_id log_messages.id%type,
p_message varchar2 --
)
as
PRAGMA AUTONOMOUS_TRANSACTION;
begin
insert into log_messages(id, message)
values (p_id, p_message);
COMMIT WRITE BATCH NOWAIT;
end;
procedure do_some_action(p_id number)
as
begin
null; -- some action
save_log(p_id, 'log entry')
end;
end utils;Errors: PACKAGE BODY UTILS Line: 20 PLS-00103: Encountered the symbol "END" when expecting one of the following: := . ( % ; The symbol ";" was substituted for "END" to continue.More Details: https://docs.oracle.com/error-help/db/ora-24344
create or replace package body utils as
procedure save_log(
p_id log_messages.id%type,
p_message varchar2 --
)
as
PRAGMA AUTONOMOUS_TRANSACTION;
begin
insert into log_messages(id, message)
values (p_id, p_message);
COMMIT WRITE BATCH NOWAIT;
end;
procedure do_some_action(p_id number)
as
begin
null; -- some action
save_log(p_id, 'log entry');
end;
end utils;Package Body created.
begin
utils.do_some_action(5);
utils.do_some_action(6);
commit;
end;Statement processed.