Home » SQL & PL/SQL » SQL & PL/SQL » SEQUENCE (ORACLE 10G)
SEQUENCE [message #332751] Wed, 09 July 2008 10:20 Go to next message
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 Go to previous messageGo to next message
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 #332755 is a reply to message #332751] Wed, 09 July 2008 10:22 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

We are NOT standing behind you.
We can NOT see what you have done.
What are you RUNNING & looking at???????????????????
Re: SEQUENCE [message #332756 is a reply to message #332754] Wed, 09 July 2008 10:23 Go to previous messageGo to next message
acarella
Messages: 21
Registered: July 2008
Location: Latham, NY
Junior Member
This is a custom application for msds
Re: SEQUENCE [message #332757 is a reply to message #332756] Wed, 09 July 2008 10:24 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
acarella wrote on Wed, 09 July 2008 08:23
This is a custom application for msds

What is "MSDS" ?
Re: SEQUENCE [message #332758 is a reply to message #332757] Wed, 09 July 2008 10:26 Go to previous messageGo to next message
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 #332761 is a reply to message #332758] Wed, 09 July 2008 10:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry about what? We just don't know what is MSDS.
I think you should call the application provider.

Regards
Michel
Re: SEQUENCE [message #332765 is a reply to message #332761] Wed, 09 July 2008 10:39 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Frank
Messages: 7880
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 Go to previous message
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
Previous Topic: Calling a Trigger from a Procedure.
Next Topic: Tables and Columns
Goto Forum:
  


Current Time: Mon Dec 05 08:32:46 CST 2016

Total time taken to generate the page: 0.16956 seconds