Guid Oracle datatype
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Guid Oracle datatype

Hybrid View

  1. #1
    Join Date
    Sep 2005
    Posts
    12

    Guid Oracle datatype

    Dear All
    i have an insert query with ID column as PK as guid. the ID is NVARCHAR(40) - and i want to insert it to DB. i get all the time the folowing error
    "could not insert......within the expected range....."
    what is the problem?? the guid has the folowing format
    "XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX")
    ??

  2. #2
    Join Date
    Feb 2005
    Posts
    158
    GUID is a sixteen byte RAW not a NVARCHAR
    http://download-west.oracle.com/docs...htm#sthref1826

    Where are you getting this "XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX" from ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width