I am using BEA 92 and oracle 10 I have a Entity bean which has a primarykey field mapped to a db column, primary key is generated from @AutomaticKeyGeneration annotation(mapped to seq_one). This works fine. I am looking for a solution which will cater to following scenrio. I am tring to implement a ejbHomeQuery method on the same entity bean which will return me the next value from another database sequence(seq_two).This sequence will not be persisted in entity bean, but will be used somewhere else. Is it possible to do "select seq_two.nextval from dual" in CMP? or is there any other way where I can get the next value from entity bean without persisting the field. Thanks, Sachin