By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
CREATE Or REPLACE PROCEDURE Add_Employee( name VARCHAR2(20), salary NUMBER(7,2), manager NUMBER, title VARCHAR2(9), commission NUMBER(7,2), dept NUMBER(2)) AS BEGIN DBMS_APPLICATION_INFO.SET_MODULE( module_name => 'add_employee', action_name => 'insert into emp'); INSERT INTO emp (ename,empno,sal,mgr,job,hiredate,comm,deptno) VALUES (name,emp_seq.nextval,salary,manager,title,sysdate,commission, deptno); DBMS_APPLICATION_INFO.SET_MODULE ('',''); END;For more examples and detailed explanations, go to Metalink and search for "Note:61722.1."
Dig Deeper on Using Oracle PL-SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.