OraFAQ Forum: SQL & PL/SQL » rarely sequence.nextval does not work

Home » SQL & PL/SQL » SQL & PL/SQL » rarely sequence.nextval does not work

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

rarely sequence.nextval does not work [message #37715]

Sat, 23 February 2002 05:03

Prashant Kakade
Messages: 1
Registered: February 2002

Junior Member

I have used sequence.nextval wrapped in a procedure which returns the new value and I call this procedure from VB code.
It works fine mostly but sometimes when I call this procedure from two different machines I get the same value. Has anybody come across such a situation.
Some of the Spec. are as follows:
Windows NT 4.0 SP4
Oracle 8i ( 8.1.5 )
Visual Studio 6.0 SP4
Microsoft ODBC Driver for Oracle
Please help me to solve the problem.

Report message to a moderator

Re: rarely sequence.nextval does not work [message #37719 is a reply to message #37715]

Sun, 24 February 2002 23:42

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

i think u have created the sequence with cache option , create it with no cache option

Report message to a moderator

Re: rarely sequence.nextval does not work [message #37727 is a reply to message #37719]

Mon, 25 February 2002 07:58

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Even with the CACHE option, one would never receive duplicate sequence values. I think we'll probably need to see the proc in order to understand the context...

Report message to a moderator

Re: rarely sequence.nextval does not work [message #37734 is a reply to message #37727]

Mon, 25 February 2002 23:21

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

hi todd,

you are right.

cheers
pratap

Report message to a moderator

Re: rarely sequence.nextval does not work [message #38607 is a reply to message #37715]

Tue, 30 April 2002 03:05

yogesh joshi
Messages: 1
Registered: April 2002

Junior Member

i want to copy some tables(actually a database) on floppy.
how to do that????
if i export a table only the values are exported.
how to export a database definition..
or a table definition

regards,
yogesh

Report message to a moderator

Previous Topic:	Re: Difference b/w varchar, varchar2 and nvarchar2
Next Topic:	UNION in SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 18:55:30 CDT 2024