1 Reply Latest reply: Apr 23, 2013 11:41 PM by swesley_perth RSS

    Raw vs VARCHAR2 for sys_guid

      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.

        • 1. Re: Raw vs VARCHAR2 for sys_guid
          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.