|
Home > Archive > BizTalk Server General > April 2006 > FROM SQL TO ORACLE
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 |
FROM SQL TO ORACLE
|
|
| Nazeedah 2006-04-27, 7:26 am |
| Hello
I am using Biztalk 2006. I have retrieve records from a sql database and
store it in an oracle database by using Biztalk.and it retrieve and insert
the records successfully.
But it has to check the records whether if exist then do not insert else
insert the records in the oracle database.
Can anyone help me of how to continue with it.i have not use any orchestra
to do the above one.
If you need any additional info, please do ask..
Regards
| |
| Alan Smith 2006-04-27, 7:26 am |
| Hi Nazeeheh,
Are you able to crerate a stored procedure in the Oracle database and call
that? If so, it should be easy to code your logic to check for existane in
that, and call it form the orchestration using the oracle adapter.
Regards,
Alan
--
The Bloggers Guide to BizTalk
http://geekswithblogs.com/asmith
"Nazeedah" wrote:
> Hello
> I am using Biztalk 2006. I have retrieve records from a sql database and
> store it in an oracle database by using Biztalk.and it retrieve and insert
> the records successfully.
> But it has to check the records whether if exist then do not insert else
> insert the records in the oracle database.
> Can anyone help me of how to continue with it.i have not use any orchestra
> to do the above one.
> If you need any additional info, please do ask..
>
> Regards
| |
| Nazeedah 2006-04-27, 7:26 am |
|
Hello Sir,
Thank you a lot for your reply.Can you please give me some more details
about the stored procedure.
Do yo mean that i have to create a produre in oracle and call that procedure
when creating the schema in Biztalk in the sql statement??
IF not, can you please explain how do you think i should do it.
Thank you in advance
|
|
|
|
|