| SEQUENCE [message #332751] |
Wed, 09 July 2008 10:20  |
acarella
Messages: 21
Registered: July 2008
Location: Latham, NY
|
Junior Member |
|
|
I have a table called
T_REP_PROD_DATASETS
it has a field called
F_SEQUENCE
in the application it is greyed out, which appears to be off or not set.
I need to turn this sequencing on.
How do I do this?
do I have to create a sequence for the field seqence?
CREATE SEQUENCE T_REP_PROD_DATASETS ??
|
|
|
|
| Re: SEQUENCE [message #332754 is a reply to message #332751] |
Wed, 09 July 2008 10:22  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
| Quote: | in the application it is greyed out, which appears to be off or not set
|
What 'application' is that then?
|
|
|
|
|
|
|
|
|
|
| Re: SEQUENCE [message #332758 is a reply to message #332757] |
Wed, 09 July 2008 10:26 |
acarella
Messages: 21
Registered: July 2008
Location: Latham, NY
|
Junior Member |
|
|
|
I just queried all the user sequences. It is there. It is greyed out so that the user cannot change it. sorry.
|
|
|
|
|
|
| Re: SEQUENCE [message #332765 is a reply to message #332761] |
Wed, 09 July 2008 10:39 |
acarella
Messages: 21
Registered: July 2008
Location: Latham, NY
|
Junior Member |
|
|
I apologize for all the confusion.
I received more information.
There is a sql server client that migrated to oracle.
Somehow the sequence on a table got dropped in the process.
I am going to the client's office at 2 pm.
I will query the sequences when I get there. If it is not there I will recreate it.
Thank you for your help.
|
|
|
|
| Re: SEQUENCE [message #332771 is a reply to message #332765] |
Wed, 09 July 2008 11:18 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
|
In Oracle it is not sufficient to have a sequence to auto-increment a column. You have to create a Before Insert Row-level trigger to fill the column with the sequence's nextval
|
|
|
|
| Re: SEQUENCE [message #332798 is a reply to message #332771] |
Wed, 09 July 2008 14:32 |
acarella
Messages: 21
Registered: July 2008
Location: Latham, NY
|
Junior Member |
|
|
Thank you all very much for your help.
I investigated the sequence. It was fine.
I then investigated the triggers (after reading the last email) and they were all disabled. I enabled them and everything is now working.
Thank you,
Arlene
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
