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_at_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"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=478260311-31072000>there
is a init.ora param that caches seq #'s. turn it off.</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Indra Harimurti
[mailto:indra_at_sofrecom.co.id]<BR><B>Sent:</B> Monday, July 31, 2000 1:24
AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> ora
01002 - Please help<BR><BR></DIV></FONT>
<DIV><FONT size=2>Dear List,</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>we have 15 sites using the same :</FONT></DIV>
<DIV><FONT size=2>- Oracle version 7.3.4</FONT></DIV>
<DIV><FONT size=2>- Digital Unix 4.0d</FONT></DIV>
<DIV><FONT size=2>- Pro*c program</FONT></DIV>
<DIV><FONT size=2>- init.ora configuration parameters</FONT></DIV>
<DIV><FONT size=2>But there is 1 site giving ORA-01002 fetch out
of</FONT></DIV>
<DIV><FONT size=2>sequence when </FONT><FONT size=2>executing the Pro*c
program.</FONT></DIV>
<DIV><FONT size=2>Can anyone </FONT><FONT size=2> give me a suggestion
what to check</FONT></DIV>
<DIV><FONT size=2>for this 1 peculiar site. Please help. TIA</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Indra</FONT></DIV></BLOCKQUOTE></BODY></HTML>
Received on Mon Jul 31 2000 - 06:04:08 CDT