Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jul 24, 2012 7:09 AM by
Adding Sequence to the set of Transactions
Jul 24, 2012 7:01 AM
My Scenario is:
Suppose an customer ordered three products at a time, then that three product rows must have single order_id(this order_id should be sequence generator).
But iam getting different order_id's for three products.....
I have add sequence generator using following code in the EO IMPL class in create method,
SequenceImpl s=new SequenceImpl("first_seq",getDBTransaction());
How can i accomplish this task...? Suggest me any relevent solution....
This content has been marked as final.
Show 1 reply
Re: Adding Sequence to the set of Transactions
Jul 24, 2012 7:09 AM
in response to
How about having two tables, one for orders, and the other (via a foreign key) with items in an order (it might have its own primary key)?
Alternatively, you may have everything in one table, but OrderId still has to have character of a foreign, not primary key.