I do not think you can do this from within the orchestration.
MY_SEQUENCE.NEXTVAL is a function that is evaluated by Oracle while processing the SQL.
You cannot put the text in the ID field as that is numeric.
One possibility would be an attribute on the field such as: <ID oracle:function=\”MY_SEQUENCE.NEXTVAL\”/> but the adapter would need to support this and I cannot see anywhere in the documentation where anything like this is supported.
You could use a stored procedure call. Or adding the data to a temp table, with a trigger to populate the real table.
Viewing 1 reply thread
The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.