Skip to Main Content

Error at line 7: PLS-00103: Encountered the symbol "/"

ANOVA-HYPOTHESISAug 20 2021

Hi,
I was following the Oracle Live SQL tutorial and I encountered the Error at line 7: PLS-00103: Encountered the symbol "/" when I attempted to run the following code I clearly copied and pasted:

create or replace trigger DEPARTMENTS_BIU
before insert or update on DEPARTMENTS
for each row
begin
if inserting and :new.deptno is null then
:new.deptno := to_number(sys_guid(),
'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX');
end if;
end;
/

create or replace trigger EMPLOYEES_BIU
before insert or update on EMPLOYEES
for each row
begin
if inserting and :new.empno is null then
:new.empno := to_number(sys_guid(),
'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX');
end if;
end;
/

The link to the tutorial is here: https://livesql.oracle.com/apex/f?p=590:1:13286540921559:CLEAR::1:TUTORIAL_ID,P1_SHOW_LEARN_SIDEBAR:66403703756642340425947956952870068,Y
Thanks!

ANOVA

Comments
Post Details
Added on Aug 20 2021
3 comments
3,126 views