Pass GUID parameter

[sjoshi]

Hello All
I'm using OraOLEDB.Oracle provider for accessing Oracle. Now I have a
column of GUID type that is stored as RAW in Oracle. How do I pass
value/type for that parameter. ?? I was using the type of the
parameter as OleDbType.Guid but it fails. My query has this end string


pd.oid=?

and that's where I need to pass the value. Should I map that to
OleDbType.Binary and send a Byte[] ?

thanks
Sunit

 

[Cowboy \(Gregory A. Beamer\)]

If you are simply using GUIDs for metadata storage (to link back to the MS
world, for example), aim for storing as a character data type. I am not sure
that storing binary gives you any benefits, although I could be wrong in
your particular instance.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************