[for] the Oracle stored procedure after insert not insert success!!!!!!!!!!-CodePudding

The create or replace procedure add_employee (
Eno number,
Name varchar2,
Sal number,
Job varchar2 default 'CLERK'
Dno number
)
Is
The begin
Insert into the employee (empon, ename, sal, job, deptno) values (eno, name, sal, job, dno);
commit;
end;

The exec add_employee (1111, 'MARY', 2000, 'MANAGER', 10);
Execute successfully, but there is no effect, bosses, look at the

CodePudding user response:

Built the same stored procedure, running can be inserted,
You can test the stored procedure and implemented step by step

CodePudding user response:

SQL> The exec add_employee (1111, 'MARY', 2000, 'MANAGER', 10);
PL/SQL procedure successfully completed

SQL> Select * from employee.
ENO NAME SAL JOB DNO
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
MARY 2000 MANAGER 10 1111

CodePudding user response:

The building Lord, you are not only create a success this stored procedure, but did not actually perform it?