• 0

[SQL] simple oracle question

Asked by eliokh,

 Share

Question

Proficient

eliokh

Posted
Posted

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

Link to comment
https://www.neowin.net/forum/topic/1072565-sql-simple-oracle-question/
Share on other sites

1 answer to this question

Recommended Posts

This topic is now closed to further replies.
 Share
Go to question listing

  • Posts

    • Microsoft CEO Satya Nadella finally addresses the elephant in the room... kind of

      By The Werewolf · Posted

      "This is despite the company inching closer to a $4 trillion market cap with each passing day." Sigh, you realise Microsoft doesn't own that $4T, right? That money is owned by investors. In fact, Microsoft is expected to hand out dividends which does come out of operating revenue, so that much market capitalisation can actually be a drain on a company, not a benefit. Microsoft's actual revenue in 2024 was around $375B with reported earnings of $155B which means that 59% of its earnings were eaten by expenses. You could legitimately argue that $155B is still a lot of money, so why lay off those workers? If we assume an average salary of $90K per worker, 9,000 workers mean $810M just in wages, which seems like small beans compared to $155B. But seriously, people have to get over market cap as a metric of anything other than investor confidence. It is NOT the measure of the actual worth of a company.
    • Spinal Tap II: The End Continues (2025)

      By BritBronco · Posted

      Looking forward to this.
    • Debian switches to 64-bit time completely to avoid Y2K38 disaster

      By The Werewolf · Posted

      You know - if you abbreviate 2038 as 2K38, it's exactly the same number of characters and so isn't actually an abbreviation - and worse, just makes it confusing for people who weren't aware of the original Y2K problem which happened 25 years ago.
    • President Trump unveils action plan to beat China in the AI race

      By Accuphase · Posted

      Well done President Trump.
    • UK enforces strict new online age checks today

      By fingletmein · Posted

      This only works for sites that care about the law. Anyone who can't or doesn't want to meet the requirements will either use a VPN or go to a (piracy) alternative that doesn't care about the law. It'll be even worse than the people having visited the law abiding sites without the verification. So way to go on that one.

  • Recent Achievements

    • Dedicated
      EYEREX earned a badge
      Dedicated
    • First Post
      Electronic Person earned a badge
      First Post
    • Week One Done
      CyberCeps666 earned a badge
      Week One Done
    • Very Popular
      d4l3d earned a badge
      Very Popular
    • Dedicated
      Stephen Leibowitz earned a badge
      Dedicated

  • Popular Contributors

    1. 1
      +primortal
      606
    2. 2
      ATLien_0
      235
    3. 3
      Xenon
      159
    4. 4
      neufuse
      131
    5. 5
      +FloatingFatMan
      124
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!