Message-Id: <10575.113346@fatcity.com> From: "Sais, Gene" Date: Mon, 31 Jul 2000 07:04:08 -0400 Subject: RE: ora 01002 - Please help This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFFADF.0FAFE560 Content-Type: text/plain; charset="iso-8859-1" there is a init.ora param that caches seq #'s. turn it off. -----Original Message----- From: Indra Harimurti [mailto:indra@sofrecom.co.id] Sent: Monday, July 31, 2000 1:24 AM To: Multiple recipients of list ORACLE-L Subject: ora 01002 - Please help Dear List, we have 15 sites using the same : - Oracle version 7.3.4 - Digital Unix 4.0d - Pro*c program - init.ora configuration parameters But there is 1 site giving ORA-01002 fetch out of sequence when executing the Pro*c program. Can anyone give me a suggestion what to check for this 1 peculiar site. Please help. TIA Indra ------_=_NextPart_001_01BFFADF.0FAFE560 Content-Type: text/html; charset="iso-8859-1"
there is a init.ora param that caches seq #'s.  turn it off.
-----Original Message-----
From: Indra Harimurti [mailto:indra@sofrecom.co.id]
Sent: Monday, July 31, 2000 1:24 AM
To: Multiple recipients of list ORACLE-L
Subject: ora 01002 - Please help

Dear List,
 
we have 15 sites using the same :
- Oracle version 7.3.4
- Digital Unix 4.0d
- Pro*c program
- init.ora configuration parameters
But there is 1 site giving ORA-01002 fetch out of
sequence when executing the Pro*c program.
Can anyone  give me a suggestion what to check
for this 1 peculiar site. Please help. TIA
 
Indra