Q: Forms 4.5 and sequence.nextval problem

From: Gary Assa <gsa_at_li.net>
Date: 1997/02/03
Message-ID: <5d5gme$fha_at_linet01.li.net>#1/1


[Quoted] [Quoted] We have a forms 4.5 form and want to use a sequence for an incremental [Quoted] [Quoted] 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). [Quoted] 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 Mon Feb 03 1997 - 00:00:00 CET

Original text of this message