Oracle ROWID as a function / procedure parameter

I just would like to hear different opinions about using the ROWID type as an input parameter to any function or procedure.

I usually used and saw primary keys used as input parameters, but are there any disadvantages to using ROWID as input parameter? I think this is pretty simple, and the selection is pretty quick if used in the WHERE clause.

For instance:

FUNCTION get_row(p_rowid IN ROWID) RETURN TABLE%ROWTYPE IS...
+3
source share
1 answer

From the manual:

rowid . ( ) . Oracle , , , rowid .

ROWID , , , :

  • (ALTER TABLE MOVE...)
  • /

, , + . ROWID , .

ROWID SQL, Oracle , , , . , ROWID, (SELECT... FOR UPDATE).

, , . , , rowid. , , , , .

+14
source

Source: https://habr.com/ru/post/1789456/


All Articles