tag:blogger.com,1999:blog-34524994.post5245876238332183929..comments2023-10-21T06:07:22.066-07:00Comments on Azure Thoughts, EAI Challenges: Polling Oracle 11g XE with OracleDbBindingSteef-Jan Wiggershttp://www.blogger.com/profile/03378054798030259210noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-34524994.post-76210047615623243222012-09-24T04:24:03.213-07:002012-09-24T04:24:03.213-07:00Hi, you need to keep a status in table you are pol...Hi, you need to keep a status in table you are polling from. See for instance samples below:<br /><br />PolledDataAvailableStatement :<br /><br /> SELECT COUNT(*) FROM [MyDb].[dbo].[MyTable] WHERE status = 0;<br /><br />PollingStatement: <br /><br /> SELECT TOP(1) [MyDataField] FROM [MyDb].[dbo].[MyTable] FOR UPDATE<br />WHERE status = 0 ;<br /><br />PostPollStatement:<br /><br /> UPDATE Steef-Jan Wiggershttps://www.blogger.com/profile/03378054798030259210noreply@blogger.comtag:blogger.com,1999:blog-34524994.post-61318649988761297032012-09-17T06:24:23.855-07:002012-09-17T06:24:23.855-07:00I'm using polling to retrieve records and its ...I'm using polling to retrieve records and its working fine but my problem is after the initial polling i want to get only updated records. How do i go about it.vamudzukwahttps://www.blogger.com/profile/15885113768675268548noreply@blogger.com