SQL & PL/SQL

Hai
I created sequence
create sequence emp_seq startwith 800 increment by 1 maxvalues 1000;
and emp table is empty.I want to set module information into v$session by dbms_application_info package.According to that i created procedure sucessufully ,i got the below error when executing the procedure


SQL> CREATE OR REPLACE PROCEDURE ADD_EMPLOYEE(NAME VARCHAR2,SALARY NUMBER,MANAGER NUMBER,TITLE VARCH
AR2,COMMISSION NUMBER,DEPARTMENT NUMBER) AS
2 BEGIN
3 DBMS_APPLICATION_INFO.SET_MODULE(MODULE_NAME=> 'ADD_EMPLOYEE', ACTION_NAME=>'INSERT INTO EMP');

4 INSERT INTO EMP(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES(EMP_SEQ.NEXTVAL,NAME,TITLE
,MANAGER,SYSDATE,SALARY,COMMISSION,DEPARTMENT);
5 DBMS_APPLICATION_INFO.SET_MODULE('' , '');
6 END
7
8 ;
9 /

Procedure created.



EXEC ADD_EMPLOYEE (EMP_SEQ.NEXTVAL,'MOHAN1', 'SYSTEM',7902,TO_DATE('17-DEC-1980','DD-MON-YYYY')
, 800,NULL, 20);
BEGIN ADD_EMPLOYEE (EMP_SEQ.NEXTVAL,'MOHAN1', 'SYSTEM',7902,TO_DATE('17-DEC-1980','DD-MON-YYYY'), 80

*
ERROR at line 1:
ORA-06550: line 1, column 29:
PLS-00357: Table,View Or Sequence reference 'EMP_SEQ.NEXTVAL' not allowed in
this context
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored