-
UPDATE: When I activate the receive location with no subscribtions to the received message, polling works fine. I get a message with 5 records in the MessageBox about every 60 seconds. The message get suspended, because there are no subscribtions. When I make a subscribtion to this messages by using...
Posted to
BizTalk 2006
(Forum)
by
Robbish
on
Thu, Jun 11 2009
Filed under: oracle, oracle adapter, biztalk 2006, BizTalk 2006 version
-
Hello, I have an Oracle 10g table with about 50 thousand records in it. I want to poll 5 records per minute to BizTalk Server 2006, to process them. I have made a Receive Port and Receive Location to do this. The Connection Properties for this Receive Location are: Delete after poll: True (tested with...
Posted to
BizTalk 2006
(Forum)
by
Robbish
on
Wed, Jun 10 2009
Filed under: oracle, oracle adapter, BizTalk 2006 Editions, biztalk 2006
-
Hello from The Netherlands, We use the BizTalk Oracle adapter in BizTalk Production/Oracle Production and BizTalk Acceptation/Oracle Acceptation environment. Both Query and Insert did work in both environments and gave a QueryResponse and InsertResponse. Oracle Acceptation environment is a clone of the...
Posted to
BizTalk 2006
(Forum)
by
Robbish
on
Wed, Apr 29 2009
Filed under: oracle, oracle adapter, BizTalk 2006 Editions, biztalk 2006
-
Hi Siva, could you post a sample of your stored procedure code? because it makes a big difference whether you use OUT CURSOR, or just a Select statement before the end of the procedure. you can try writing statements like "Select Owner.PackageName.ProcedureName from dual". this should work...
-
Hi Gurus, I have an active-active cluster biztalk server 2006 setup. upon which i have a receive location that make use of Enterprise oracle adapter. This receive adapter is configure to "Poll SQL Statement" like [select * from table_123 where status_id='1'] and "Post Poll SQL...
Posted to
BizTalk 2006
(Forum)
by
Anonymous
on
Mon, Feb 4 2008
Filed under: oracle, odbc adapter, 2006, Best Practice, biztalk 2006, Architecture, adapter
-
Hello, I configured a Receive Port / Receive Location using the OracleDb-adapter. My polling SQL calls a stored procedure inside the database (SQL = "exec myStoredProc;") The procedure itself is defined as CREATE OR REPLACE PROCEDURE myStoredProc (someOutParam1 OUT VARCHAR2, someOutParam2 OUT...
Posted to
BizTalk 2006
(Forum)
by
t-mx
on
Wed, May 30 2007
Filed under: oracle, oracle adapter, ports, 2006, BizTalk 2006 Editions, biztalk 2006, BizTalk
-
Hello, I have to access an Oracle DB by using the Oracle-adapter for BTS 2006. Visual Studio is running on my developer box, BTS is running on a server and is added to the BizTalk Explorer inside VS. On my developer box, there is no BTS installed. I now want to generate the schema for the data, that...
Posted to
BizTalk 2006
(Forum)
by
t-mx
on
Tue, May 29 2007
Filed under: oracle, oracle adapter, ports, 2006, BizTalk 2006 Editions, biztalk 2006, BizTalk
-
Hello, I have an equivalent problem, as you can see below : Event Source: BizTalk Server 2006 Event ID: 5743 System defined exception Call to MyStoredProcedure@OracleDb://MyOdbcSystemDSN/MyOracleSchema/Procedures/PK_MY_PACKAGE Implementation = OracleDb://MyOdbcSystemDSN/MyOracleSchema/Procedures/PK_MY_PACKAGE...
-
My first question is what version of Oracle are you using? If 8i, perhaps Top Level will actually work. For 9i and 10g, it will not. You need to use a Package and generate schemas based on the package. I have used packages specific to the Orchestration so as to cut down on the size and complexity of...
-
Was your problem resolved? Your namespace should have been more like: http ://schemas.microsoft.com/[MyOracleDbAdapter://< DataSourceName >/< OracleSchema >/Tables/SAMPLE_XCHANGE] If you generate a new schema check that against the one you have now. Once someone changes the Oracle database...