using cursor after commit

We are trying to use cursors with MODE=ORACLE and the ProC precompiler.

We have three tables we are using: one table is our source and has the cursor set to fetch 100 rows at a time. The other two are created and are filled with data from the first. After inserting a 1000 rows into these two tables we do a commit(see note 1). After this commit we have to reopen the cursor, if we don't reopen the cursor we get a cursor error. After we reopen the cursor it is set to the beginning of the source table, which is not good.

Questions:
Is using a cursor like this with MODE=ORACLE ok?

How do I tell if I am in MODE=ORACLE from the Pro-C precompiler? It seems as if this is

acting like MODE=ANSI. I tryed using 'proc ?' at the command line which says we are in

MODE=ORACLE, but I'm wondering if the PRO-C precompiler is overiding this somehow.

Notes:
(1).We do this because the source table can be huge and we don't want our rollback file to become to big.

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net