Re: Q: Forms 4.5 and sequence.nextval problem

Create a synonym to point to the sequence:

CREATE SYNONYM sequence_gen FOR SCHEMA.sequence_gen;

You can create a private or public synonym.

You may also have to grant privileges on the sequence generator to your development schema to be able to update the generator.

In article <5d5gme$fha_at_linet01.li.net>, gsa_at_li.net says...
>
>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???
>--
>=========================================================
> http://www.li.net/~gsa/index.html
>This is my signature file, not part of this mail message.
Received on Tue Feb 04 1997 - 00:00:00 CET