| malmeida 2007-12-26, 1:20 pm |
| Hi,
I am using oracle adapter with biztalk server 2006. I have an oracle
database and i need to execute a stored procedure.
Example:
I have a table and i do a delete after poll with the table change event,
this works fine when i only have one record. But if i have multiple records
this don't work how i expected. I have resolved this, on the receive port i
configured the property Event Max Row Count -> 1. Now if i have multiple
records, create one "message" for each one record. Now i have to call a
stored procedure, the first records that is polled from the table is process
immediately, but the other ones i need to wait 5 minutes for each one. I have
tried to change some properties from the the oracle port, but i don't know
what is the correct property. I tried refresh agent but if i open again i put
always to "no".
Please, if some one know how to help me, please respond.
Thank you.
|