Error inserting:ORA-02289: sequence does not exist

Applications Forms
#1

Help…
i have error in my form with oracle database
Error inserting:
ORA-02289: sequence does not exist
but when the sql execute in toad ,record succes insert to database
please help me…why

#2

Re: Error inserting:ORA-02289: sequence does not exist

It will be a privileges problem, you need to have the correct permissions granted to the sequence for the user you are logging in as. There is lots of info on the web about granting privs to users but if your not too security conscious, just put in

grant all on <sequence> to <user>

#3

Re: Error inserting:ORA-02289: sequence does not exist

Thanks …very much
problem is solved