RE: Oracle adapter issue in BizTalk
- From: Bembeng Arifin <BembengArifin@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 13 Apr 2008 19:17:00 -0700
Hi Raja,
When you said retrieved values from SP using oracle adapter, were you using
this for Poll Statement? And are you using BizTalk 2006 Server with Oracle
Adapter (ODBC Connection)?
Thanks.
"Raja" wrote:
I retrieved values from SP using Oracle adapter. No issues from my end..
Check your package(SP) if it's not coming into BTS. Otherwise send your
package to me which one you are trying from your end.
-Raja kumaravel
"Siva" wrote:
Hi Raja,
Thank you. The problem I am facing is, package-procedure returns recordset.
How can I retrieve multiple records using oracle adapter?
My procedure in the package returns ref courser(recordset). I guess that is
why add generate items could not create schema.
I want to retrieve multiples record from table using procedure. Any idea?
--
Thank you,
Siva
"Raja" wrote:
Siva,
Did you execute your package and also package body using TOAD.
I'm working on same scenario. It's good from my side.
Thanks,
Raja Kumaravel
rajatpk@xxxxxxxxxxx
"Siva" wrote:
Hi,
I am trying to retrieve data from oracle table using BizTalk oracle adapter.
I have the quary in package. I have to use package for this project.
I could not create Oracle schema from "add Generate Items" wizard using
package. When i run the "add generate items" for the package, using the
receive port that connect to the db, it is creating object schema and
orchestration only, not procedure schema.
How can I use procedure(package) to retrieve data from Oracle database in
biztalk 2006 R 2?
--
Thank you,
Siva
- Prev by Date: Delivered but not consumed
- Next by Date: RE: Biztalk schema change question
- Previous by thread: Delivered but not consumed
- Next by thread: Transaction sharing and message integrity
- Index(es):
Relevant Pages
|
