i have an insert statement in my procedure and i m using the cursor value in it ..
insert into sample(sid,sname) values(cursor1.sid,cursor1.sname);
and when i try to execute the procedure it gives the error
PL/SQL: ORA-00984: column not allowed here
so what is the cause for this error.i CANNOT POST THE PROC AS IT TOO BIG. Can anyone help me with this.