Hello Ranchers,
I'm doing a program in
JSP and Oracle.. In that the oracle table details are here
------------------------------------------------------
column
------------------------------------------------------
reg_no
name
password
confirm
-------------------------------------------------------
in this table the reg_no is a primary key and there is a sequence
ie., the number starts with 1000 and increment by 1
now from the jsp page.. i want to insert a new user registation details..
at that time the query i;m using is
insert into table_name (reg_no,name,password,confirm)values (reg_no.nextval,name,password,confirm); but it is not inserting and showing errors..
so what should i do to insert the values in to the table where there is a sequence and a primary key!!
please help me.. ranchers..
thanks in advance
regards
Megha Rajeev