1 Reply Latest reply on Apr 24, 2013 4:41 AM by swesley_perth

    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.
          1 person found this helpful