|
Home > Archive > BizTalk Server Orchestration > April 2006 > How to get oracle nextval use functoid
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to get oracle nextval use functoid
|
|
| Mapping question 2006-01-24, 2:48 am |
| 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
| |
|
| 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
|
|
|
|
|