which version are u using.

first of all does "OR REPLACE" really works ????

i tried the same statements. it worked fine with me.

did u get "SEQUENCE CREATED" after the create statement.