Cross Schema Sequences

Posts   
 
    
Phuzakie
User
Posts: 13
Joined: 10-Nov-2006
# Posted on: 05-Nov-2007 22:41:39   

This problem comes from the unique database structure Ive outlined in my other thread...

Basically, I have customerOne.Location and customerTwo.Location that I both need to use core.LocationSequence.

The problem is that in the editor, I can only assign sequences that are in the same oracle schema as the entity.

Any work arounds?

Walaa avatar
Walaa
Support Team
Posts: 14983
Joined: 21-Aug-2005
# Posted on: 08-Nov-2007 14:56:00   

Would you please try to add a synonym for each sequence to the core schema you have.

But we think you'll quickly run into the problems you've described in that other thread. http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=11704 You should use name overwriting as Frans has explained in the thread linked above, then sequences are used automatically.