1 Reply Latest reply: Apr 23, 2013 11:41 PM by scott.wesley RSS

    Raw vs VARCHAR2 for sys_guid

    1004934
      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.

      Thanks,
        • 1. Re: Raw vs VARCHAR2 for sys_guid
          scott.wesley
          I've never experienced a problem - Amanda refers to it here
          http://nerd.net.au/40-sql-a-plsql/useful-functions/107-sys-guid
          and talks about it further here
          http://www.nerd.net.au/oracle/29-apex-application-express/general-application/109-4-2-development-standards

          Check out how the package application "Customer tracker" generates IDs.