How to fix the rowid problem in PL/SQL where migrating from 7.3.4 to 9i ?
We use lots of rowid in PL/SQL migrated from Oracle 7.3.4 to 9i. How can I fix this problem ? Any tools ? Any tricks ?
Thanks a lot !!!
How to fix the rowid problem in PL/SQL where migrating from 7.3.4 to 9i ?
We use lots of rowid in PL/SQL migrated from Oracle 7.3.4 to 9i. How can I fix this problem ? Any tools ? Any tricks ?
Thanks a lot !!!
I which way u are using .Are u hard coded it or not ?
If you usesomthing like the follwoing you're OK:
DECLARE
v_rowid ROWID;
BEGIN
SELECT rowid
INTO v_rowid
FROM emp
WHERE empno = 1234
FOR UPDATE;
-- Do something
UPDATE emp
SET sal = 2000
WHERE rowid = v_rowid;
COMMIT;
END;
/
If you actually store the rowids in a table, or generate them manually your screwed. You can use the DBMS_ROWID package to convert them but I wouldn't bother.
You should really consider re-engineering your system to avaios the use of stored rowids if possible. As well as this upgrade issue you are prevented from using export/import.
Cheers