I have problem creating the mapping of entities to the oracle guid fields. I have version 3.0. Thanks for any help

Hi casama.

Please give us more information about your problem: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7721

What are the steps to reproduce your problem?

Additionally, next time please post directly into Designer forum (if the problem is in the designer) or GeneratedCode forum (if you have a problem with your code).

Also keep in mind that Oracle doesn't support Guid types, so you need a typeconverter to convert from guid to a type oracle does support (e.g. char(30))

Thanks for answering. My problem is this.

The key field of my entities is guid. When I create the mapping in the "Field mappings" tab -> Create Mapping -> New target..., I create all the columns of my entities except my key field(guid).

I know that Oracle doesn't support Guid types. I want to use the ROW type. Then, I would have to manually create my key field? In this case, is there any converter for GUID type to ROW type?

Thanks again

Assuming you mean RAW datatype, rather than ROW - we think there is an issue using this for PK fields. Your best bet for a guid would be to use char(32) and use a type converter to go backwards and forwards between this and the database field.

The following thread should have the information you need to get started.

http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=18111&HighLight=1

Matt