↓
 

EvROCS

Completing the puzzle

  • Home
  • Evenementen
    • = Lijst van evenementen =
    • KScope
      • KScope Algemeen
      • KScope15, Hollywood Florida
      • KScope14, Seattle
      • KScope13, New Orleans
      • KScope12, San Antonio
    • Kerstmis 2013
    • OPP 2007
  • CV
  • Quotes
  • Contact
  • EScope
  • Downloads
    • Query KScope Sessies
  • Blog
Home→Tags oracle

Tag archieven: oracle

It’s so easy to pick the wrong one                                         #JoelKallmanDay

EvROCS Geplaatst op 2023-10-11 door Erik van Roon2023-10-10

I started this blog enthusiastically. And then life happened. Today is Joel Kallman Day, so it seems a good day to pick this up again. Some time ago I ran into a problem with my code, where the cache for a result cache function wasn’t invalidated if DML was performed on the table the function selected from.This led to the function returning old values because it was under the impression the cache was still valid.I’ve checked and seen this behavior in all versions between 12.1.0.2 and the currently highest available version 23c FREE. In the end it turned out to be caused by a “for update” clause that I unintentionally copied when I put the query into the function from someplace else.So, it wouldn’t have happened if paid more attention to what I was copying.Nevertheless, the combination of a result cache and a “for update” is as far as I … Lees verder →

Geplaatst in PLSQL, SQL | Getagged for update, function, invalidate, oracle, plsql, Result cache, sql | Geef een reactie

Talen

  • Nederlands
  • English (Engels)

Zoeken

Subscribe for notification of new blogposts

Subscribe to email notifications for new blog posts

Loading

RSS

  RSS Feed Blog Posts

  RSS Feed Comments

Recente berichten

  • It’s so easy to pick the wrong one                                         #JoelKallmanDay
  • Your library is your paradise
  • Hit the road Jack, and don’t you come back no more….
  • Being in command
  • A Person who won’t read has no advantage over one who can’t read

Follow me on Twitter

Erik van Roon Volgen

Oracle DB Dev Oracle ACE Pro ♠️ Symposium42 Rambling fool By default assume I'm not serious Tweeted opinions are the one & only truth, and probably unfounded

evrocs_nl
Retweeten op Twitter Erik van Roon Geretweet
poug_org ORA-600 @poug_org ·
vr 2025-04-25 09:03

It's time to break the silence. #POUG2025 is not just a fun conference. It can be dangerous.
@evrocs_nl Van Roon was the first to speak loudly about the consequences of attending our event.
https://poug.org/edycja/poug-2025/

Retweeten op Twitter Erik van Roon Geretweet
ora600pl Kamil Stawiarski @ora600pl ·
za 2025-04-12 14:10

Who wants to simulate OCI on premises to play with 23ai at home?

https://blog.ora-600.pl/2025/04/12/simulate-oracle-cloud-on-kvm-olvm/

Retweeten op Twitter Erik van Roon Geretweet
poug_org ORA-600 @poug_org ·
vr 2025-04-04 10:06

Vergiss langweilige Konferenzen mit Verkaufsmaschen und null Mehrwert 🙄

Komm zu einem 100 % Tech-Event direkt hinter der Grenze - und werde Teil einer einzigartigen Community. #POUG2025 wartet im September auf dich! 🔥

https://poug.org/en/

evrocs_nl Erik van Roon @evrocs_nl ·
do 2025-03-20 16:02

#APEXWorld25 by @nl_OUG
One of the wonderful events that values new speakers and thus actively advertises for the @mashprogram
Thanks guys!

Retweeten op Twitter Erik van Roon Geretweet
nl_oug nlOUG @nl_oug ·
vr 2025-03-14 09:00

On March 20, we will celebrate 15 years of APEX World with an evening of entertainment. Prepare for an evening to remember! You just might win a prize!

Get your tickets for APEX World so you can join in on the fun! https://nloug.nl/events/apex-world-2025/

#orclAPEX #aw25

Load More...
©2025 - EvROCS - Weaver Xtreme Theme
↑