kbabu1
4th January 2008, 18:59
I see the following error occuring quit often (in Customisation)

Can anyone give me a clue on why we get this error?

[ *******************************************************
1 : process 27 - Error : SQLState QP999: database error 1002 (error 2002) (tssocdll0000.reprice.part.data() in object otssocdll0000)

2 : process 27 - Fatal error : Error 2002 (database error 1002) on select

3 : process 27 - Fatal error : Can not continue in tssoc2200m200 in DLL: otssocdll0000 (tssocdll0000.reprice.part.data)[wait.and.activate]
********************************************************]

Thank you in advance for the help,

dave_23
4th January 2008, 21:46
if this is for your oracle system here is the error.


01002, 00000, "fetch out of sequence"
// *Cause: This error means that a fetch has been attempted from a cursor
// which is no longer valid. Note that a PL/SQL cursor loop
// implicitly does fetches, and thus may also cause this error.
// There are a number of possible causes for this error, including:
// 1) Fetching from a cursor after the last row has been retrieved
// and the ORA-1403 error returned.
// 2) If the cursor has been opened with the FOR UPDATE clause,
// fetching after a COMMIT has been issued will return the error.
// 3) Rebinding any placeholders in the SQL statement, then issuing
// a fetch before reexecuting the statement.
// *Action: 1) Do not issue a fetch statement after the last row has been
// retrieved - there are no more rows to fetch.
// 2) Do not issue a COMMIT inside a fetch loop for a cursor
// that has been opened FOR UPDATE.
// 3) Reexecute the statement after rebinding, then attempt to
// fetch again.