Home > database >  An error when creating inclusions PLS - 00103, consult everybody how should handle
An error when creating inclusions PLS - 00103, consult everybody how should handle

Time:09-16

The create or replace PACKAGE BODY emp_mgmt AS
Tot_emps NUMBER;
Tot_depts NUMBER;
The FUNCTION hire
(last_name VARCHAR2, job_id VARCHAR2,
Manager_id NUMBER, salary NUMBER,
Commission_pct NUMBER, department_id NUMBER)
RETURN the NUMBER of IS new_empno NUMBER;
The BEGIN
The SELECT employees_seq. NEXTVAL
INTO new_empno
The FROM DUAL;
INSERT INTO employees
VALUES (new_empno, 'First' and 'Last', '[email protected]',
'(415)555-0100', '18 - JUN - 02', 'IT_PROG', 90000000, 00,
100110);
Tot_emps:=tot_emps + 1;
RETURN (new_empno);
END;

The final END of the semicolon suggests there is an error. Why consult everybody complains? How should change
Error (19, 4) : PLS - 00103: Encountered the symbol "end - of - file" when expecting one of the following: the begin end function pragma procedure

CodePudding user response:

Less end; !

CodePudding user response:

Is really a less end;


Finally the end; Is, in fact, the corresponding function, also has a corresponding package,

CodePudding user response:

Thank you ~ ~ understand
  • Related