We are running some tests trying to see if there is an issue with defining our PK columns as RAW and using the sys_guid function as the default.
We cannot see any issue with selecting the value, using it in SQL or returning it in a PL/SQL function and using that returned value in an SQL statement join condition.
What or where should we be concerned with seeing any type of issue.
I've never experienced a problem - Amanda refers to it here
and talks about it further here
Check out how the package application "Customer tracker" generates IDs.