If you have an existing Oracle database, and you wish to take advantage of FIND PREV/LAST statements and cursor repositioning in an OpenEdge application for this database, you must manually add the PROGRESS_RECID.
To manually add PROGRESS_RECID to the Oracle database:
1. Using SQL*Plus, log in as the Oracle user who owns the table.
2. Create a sequence generator for the table named table-name_SEQ. Start with 1 and increment by 1, as shown:
CREATE SEQUENCE
table-name _SEQ START WITH 1 INCREMENT BY 1;
3. Add a column to the table named progress_recid. This column holds a number that can be null. For example:
ALTER TABLE table-name ADD (progress_recid number null);
4. Update the table and set the progress_recid using table-name_SEQ.nextval, as shown:
UPDATE table-name SET progress_recid = table-name_SEQ.nextval;
5. Create a unique index name, table-name##progress_recid, that consists of just the progress_recid column, as shown:
CREATE UNIQUE INDEX table-name##progress_recid ON
table-name (progress_recid);
6. Drop every non-unique index from the table and recreate it using the same components. Add progress_recid as the last component, as shown:
DROP INDEX table-name##index-name;
CREATE INDEX table-name##index-name ON table-name (column-name, progress_recid);
7. Verify that the sequence was created. For example:
SELECT table-name_SEQ FROM sys.dual;
8. Connect to Oracle and use the Data Dictionary's Oracle utilities to update the schema holder.
