Database Error Messages

If caused by the first reason, create a body for the object that is being referenced. If caused by the second reason, move the sequence into a SQL statement. For example,

i := seq.nextval;

can be replaced by:

select seq.nextval into temp from dual; i := temp;

If caused by the first reason, create a body for the object that is being referenced. If caused by the second reason, move the sequence into a SQL statement. For example,

i := seq.nextval;

can be replaced by:

select seq.nextval into temp from dual; i := temp;

If caused by the first reason, create a body for the object that is being referenced. If caused by the second reason, move the sequence into a SQL statement. For example,

i := seq.nextval;

can be replaced by:

select seq.nextval into temp from dual; i := temp;