- This topic has 1 reply, 1 voice, and was last updated 9 years, 3 months ago by
.
-
Posts
-
-
Hi
I want to insert and retrive data from Oracle 10g database in BizTalk server 2006.
I am able insert data in database with help of table selected from drop down list.
But I want to use procedure to insert data and packages to retrive data from database.
How can I do this?
when i add the oracle database adapter for package it doesnt give proper schema .
for sql adapter we add "for xml auto , xmldata " , like that is there any new thing for oracle adapter ?
Plz provide me any link to do this.
Thanks
-
If you're using a SPROC, try using OUT modifiers to retrieve data. This assumes you're doing this because you have control over and familiarity with Oracle. You can use a View in place of a table for repeatable queries, then you know what's being returned.
If you want to generate dynamic queries, no matter whether you use Native or a Sproc to call Oracle, you'll need to do some heavy-lifting to parse the response data. Although I haven't tested this, I'd suggest a sproc that returns XML. This could be interesting. J
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.