Forum Stats

  • 3,757,253 Users
  • 2,251,213 Discussions
  • 7,869,779 Comments

Discussions

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

ANOVA-HYPOTHESIS
ANOVA-HYPOTHESIS Member Posts: 8 Green Ribbon

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

Answers