Use Oracle sequence from an insert SQL command

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

Information Online

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Use Oracle sequence from an insert SQL command

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Use Oracle sequence from an insert SQL command

Page: [1]

Message

<< Older Topic Newer Topic >>

Use Oracle sequence from an insert SQL command - 14 February 2005

edeshaies

Posts: 10
Score: 0
Joined: 9 February 2005
Status: offline

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

_____________________________

Éric Deshaies
Analyst/programmer
eric_deshaies@lgs.com

Post #: 1

RE: Use Oracle sequence from an insert SQL command - 15 February 2005

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

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.

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to edeshaies)

Post #: 2

RE: Use Oracle sequence from an insert SQL command - 15 February 2005

edeshaies

Posts: 10
Score: 0
Joined: 9 February 2005
Status: offline

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?

_____________________________

Éric Deshaies
Analyst/programmer
eric_deshaies@lgs.com

(in reply to Pieter)

Post #: 3