Use Oracle sequence from an insert SQL command (Full Version)

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters



Message

edeshaies -> Use Oracle sequence from an insert SQL command (14 February 2005)

Hello,

I have an Oracle sequence which give me the next value for an ID in my table.

Is these a way to use the "Nextval" function in an insert schema via BizTalk Adapter for Oracle (without a store procedure)?

INSERT INTO myTable (ID,NAME,ADRESS)
VALUES (mySequence.NEXTVAL,'ERIC DESHAIES','xxx 5e street');

Or. Can I put "mySequence.NEXTVAL" as default value in my destination schema?

Thanks



Pieter -> RE: Use Oracle sequence from an insert SQL command (15 February 2005)

We have seen clients do this before without any issues.

What is the desitnation data type of the Field?

Another alternative would be to use the DB Lookup Functoid to look up the next value.

Please let us know if you have issues with this.



edeshaies -> RE: Use Oracle sequence from an insert SQL command (15 February 2005)

Good afternoon,

The data type of this element field in my XML is 'decimal' and the data type in Oracle is 'Number(12)'.

Should I change the data type in my XML to String and send 'mySequence.NextVal' in it?



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.015625