ORA-02201: sequence not allowed here Cause: An attempt was made to reference a sequence in a from-list. Action: A sequence can only be referenced in a select-list
985011 wrote:No, the dual table is most definately NOT listed in all_sequences. You have a sequence named DUAL. It is that sequence that is showing when you query all_sequences.
when select all sequence
dual table is there in the sequence list
select * from all_sequences
please check with the linksInstead of forcing us to go look at a website that is blocked by many of our networks, please issue your queries in sqlplus so that you can copy the entire query and result and paste the text directly into your posts.