Oracle Forms

Hi All,

I have googled for this issue but could not found the solution.

Here is my scenario.

In Pre-Insert trigger of form, I have called few validation procedures and select statement to fetch nextval of the sequence from the dual.

When User loggin into forms Application and tried to insert an record, User ending up with Pre-insert trigger exception saying ORA-00942 Error.

ORA-00942 says 'Table or View does not exists'.

But in Pre-Insert Trigger I have only validation procedure and A select statement for nextval of the sequence.

Users are assigned with roles which have sufficient privileges. Even though I am getting the above exception

I have run the select seq.nextval from dual using Toad, Nextval is generated.

When I give a select privilege on that sequence to the user, user is able to insert record without any exception through form.

When I revoke back that select privilege on that sequence to the user and tried to insert a record again I am getting that Pre-Insert Exception.

I work on Forms 11g with Oracle 10g Database

Can anyone help me.

Thanks,
maddy