| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Cursor and 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.
 |
 |