23/09/2016

[PL/SQL] existing state of package has been invalidated error

After compiling Oracle packages, it is possible to get a "existing state of packages has been discarded" or "existing state of package has been invalidated" error.

The cause is usually a global variable or constant declared in the package or package body that is re-initialized after the compilation action. The error is thrown to avoid having programs read the wrong state (variable/constant) of the package.

The easiest way to solve this issue is to simply disconnect the session and reconnect.

28/08/2016

Antibes.. Ooh belin!

France might have some tasty stuff, but in the end we all know they always choose pure Italian meat over frogs



Click on the image to view the full album

14/08/2016

Street parade 2016 - Open the gates

Take the quietest city ever and place a love parade in the middle. What do you get?

Click on the image to view the full album

07/08/2016

Fruenalp, climbing to Valhalla

The Schweizerklettersteigmannschaft said that beer tastes better after a 700 meters climb. We verified.


Click on the image to view the full album

01/08/2016

Zurich-Rapperswil tracks on fire

Memo: bring a spare set of balls if you cycle for a while



Click on the image to see the full album