Oct 04, 2016 11:49 PM|Lannie|LINK
If this named sequence object does not exist, ||p_table||'_seq.nextval then nextval will fail.
If p_table = let's say the table PEOPLE then PEOPLE_SEQ must exist as a SEQUENCE OBJECT (not column name) in the same owner schema for nextval call to work.
Schemas own database objects
and other things