Hi,

When I receive customer EDI(for example: orders) then must insert into
Oracle database. But oracle database table structure has a rkey, so i used
SELECT SEQ_TableName.NEXTVAL FROM DUAL to get a key in the VB. but I dont'
know how to get value use functoid in the mapper.
Could anyone give me tip?
any help would be appreciated.
Thanks,
John

[ Post a follow-up to this message ]

Hi,

In your transformation : maybe you can map it directly into the fied with a
Concatenation string with 1 constant : "SEQ_TableName.NEXTVAL".

The result may be like this :

Insert into <your table> (mykey, myfield1, myfield2) values
(SEQ_TableName.NEXTVAL, fieldvalue2, fielvalue3)

I haven't try this, but i think it works great.

Second solution : put a trigger directly into your table on insert to make
this.

snap.

"Mapping question" wrote:

> Hi,
>
>  When I receive customer EDI(for example: orders) then must insert into
> Oracle database. But oracle database table structure has a rkey, so i used
> SELECT SEQ_TableName.NEXTVAL FROM DUAL to get a key in the VB. but I dont'
> know how to get value use functoid in the mapper.
>   Could anyone give me tip?
>   any help would be appreciated.
>   Thanks,
>    John

[ Post a follow-up to this message ]