working with sequence in forms [message #575728] |
Sat, 26 January 2013 01:56 |
|
furqan
Messages: 115 Registered: January 2012 Location: Hyderabad
|
Senior Member |
|
|
CREATE SEQUENCE hyd1_seq
START WITH 2100000
INCREMENT BY 1
NOCACHE
NOCYCLE;
this is how i created a sequence in database 10g.
if :SHIP_MSTR.PLACE_FROM = 'hyd1' then
SELECT hyd1_seq.NEXTVAL
INTO :SHIP_MSTR.BILL_ID
FROM dual;
this is how iam calling sequence in form.
my problem is once the sequence is generated in form and even if i am not saving a form
its generating next value next time.what i want to do is if i am not saving the form
that sequence number should again come in bill_id.
Thanks in advance for your help.
regards
|
|
|
|
|
Re: working with sequence in forms [message #575733 is a reply to message #575731] |
Sat, 26 January 2013 03:29 |
|
Michel Cadot
Messages: 68684 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You cannot avoid loss of numbers.
Imagine 2 sessions, one takes a number, the other (and subsequent) one takes the next number, the first one does not save, so its number is lost.
Loss of numbers is inherent to multi-session.
Regards
Michel
[Updated on: Sat, 26 January 2013 03:30] Report message to a moderator
|
|
|