↓
 

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 invalidate

Tag archieven: invalidate

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
oraclesqldev Oracle SQL Developer @oraclesqldev ·
do 2023-12-07 16:11

Version 23.1.1 is now available for download with several critical bug fixes, including an updated Java 11 Home for Windows and Macs.

https://social.ora.cl/6016RJNsE

evrocs_nl Erik van Roon @evrocs_nl ·
do 2023-12-07 16:38

A 40 minute delay, but I'm on my way to London with my wife for a long weekend of tourism.

2

Retweeten op Twitter Erik van Roon Geretweet
swissouc Swiss Oracle User Community @swissouc ·
di 2023-12-05 10:42

⏰56 days until #DCC2024 takes place!

✨Time to meet our speakers! ✨

@patch72 will introduce you to the different SET operations of SQL and how to use them to solve a puzzle! 🎲

🎫Still waiting for a ticket?
http://dcc2024.swissouc.ch

#SwissOUC @oracleace

Retweeten op Twitter Erik van Roon Geretweet
alexnuijten Alex Nuijten @alexnuijten ·
di 2023-12-05 10:17

Het heerlijk avondje is gekomen! Moet je nog een last-minute kadootje 🎁 vinden?
Er zijn nog kaarten 🎟️ beschikbaar voor de @nl_OUG Database Cloud Dag a.s. vrijdag.
Programma en inschrijven: https://nloug.nl/events/database-cloud-dag-2023/

.. en moet je dan eens die blije gezichtjes zien 😊

Retweeten op Twitter Erik van Roon Geretweet
jen_s_nicholson Jen Nicholson @jen_s_nicholson ·
ma 2023-12-04 18:36

If you love #orclAPEX, check out these 2 CfPs!
@nl_OUG APEX World - by Dec. 8
@APEXAlpeAdria - by Jan. 31

https://nloug.nl/events/call-for-papers-apex-world-2024/
https://www.aaapeks.info/home

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