ProC Code - Error ORA-1002 Fetch Out Of Sequence

we have an application currntly running on an HP UX system that uses Oracle 9i database. the pro*C codes work fine with Oracle 9i, on the older system. however now we are migrating it to LINUX system (ORACLE 10g). in the new system we are facing issues with fetch statement

here is how we have the

the cursor statement:

EXEC SQL DECLARE diff_cns_list CURSOR FOR
select PREV.CNS_CODE,
PREV.CNS_DESCRIPTION,

[code]....

the code runs fine in the old operating system (HP UX) where oracle 9i was used. but fails in Oracle 10g(OS-LINUX).

the probable reason that we found out is that: the fetch statement returns zero rows, that is the reason why this error is being displayed. but Oracle 9i seemed to work out well with this.

we tried reducing the cursor conditions, where it fetches 3 rows. this is when is the fetch statement works fine.

the functionality of the code is that it should work fine even with no rows selected. Is there a way we can modfy the code to work with zero rows as well.

the error we are getting is : ORA-01002: fetch out of sequence
==========================
as per what is given in Oracle sites:

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.

========================
we have checked:

1>this is not the case and ORA-1403 not returned

2>No update statements involved , there is a insert statement which inserts data in this table

3>i am not clear with this one.