SQL & PL/SQL

Hi all,

I'm using oracle 10g.

i have a procedure

CREATE OR REPLACE PROCEDURE NEW.SP_ADDUSER (GETFNAME IN VARCHAR2,GETLNAME IN VARCHAR2,GETLOGINID IN VARCHAR2) IS 

BEGIN

EXECUTE IMMEDIATE  'INSERT INTO NEW.USERS (USERID,FNAME, LNAME,LOGINID) VALUES (RULE_SEQ.NEXTVAL, GETFNAME,GETLNAME,GETLOGINID)';


END SP_ADDUSER; 

this compiles with out any errors and warnings.

but when i try to execute the procedure i get the following errors

ORA-00984: column not allowed here
ORA-06512: at "URS.SP_ADDUSER", line 5
ORA-06512: at line 11

can you please let me know what i'm doing wrong. for userid i need an auto increment. so i created a sequence.

thanks all in advance

Edited by: Bob on May 22, 2012 7:19 AM