Forms 3 and restricted rowids in a cursor

[thrybergh]

Hi

We recently migrated our 7.3.4 database to version 9.2 but we have several Forms 3 apps running which reference ROWID.

Because of the different ROWID format from 7 to 8, we had errors with the PL/SQL in the triggers (V2), e.g.

WHERE A.ROWID = :BLK003.ROWID

I have used calls along the lines of:

DBMS_ROWID.ROWID_TO_RESTRICTED(A.ROWID,0)  = :BLK003.ROWID

and in most cases this has avoided the problem.

However, where the PL/SQL in the .INP files uses a cursor, the Forms 3 compiler returns errors stating:

PL/SQL error 302 at line 24, column 18:
   component 'ROWID_TO_RESTRICTED' must be declared

Is there anything I can do to make the ROWID_TO_RESTRICTED call work within a cursor?


Thanks