Re: Q: Forms 4.5 and sequence.nextval problem

Gary Assa wrote:
>
> We have a forms 4.5 form and want to use a sequence for an incremental
> number. The problem we are having is that the sequence is in another
> users schema. If we try to compile the trigger, it fails with internal
> error. We create a dummy sequence in our schema and it works fine (which
> answers the question whether sequences as a general rule cause a problem).
> In SQL*Plus we can increment the sequence for the other user, but not in
> forms. What is a workaround???

  GRANT SELECT ON seq TO user
  directly instead of through role.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841