[SQL] simple oracle question

[eliokh]

Hello.

I have a table in my database that is being filled with a new record when ever a certain event occurs (SMS is received).

(The insert in this table is handled by an external software i purchased).

In addition, i have scheduled a job in oracle to check for new records in this table every 2 seconds.

The problem is whenever the record is added by the external software, the job is not being able to get the new record,

but if i entered the record manually it is being spotted by the record.

I am sure that it is not a commit problem (wont explain why now....)..

Can anyone suggest any possible cause/solution?

thank you in advance

[CentralDogma]

Are you doing this with a trigger? Perhaps your table is mutating.