Rob van Wijk

Subscribe to Rob van Wijk feed
Simplicity is the ultimate form of elegance and sophisticationRob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.comBlogger153125
Updated: 17 hours 17 min ago

Back from Tallinn, Estonia

Sat, 2011-06-11 16:22
This morning I arrived back from a trip to Tallinn. Oracle Estonia had given me the opportunity to present my SQL Masterclass seminar at their training center in Tallinn, on Thursday and Friday. Thank you all those who spent two days hearing me. Here is a short story about my trip including some photos.I arrived at Tallinn airport around 1PM local time on Wednesday. My hotel room was located at Rob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.com0

Instrumentation packages

Thu, 2011-05-26 11:00
At CIBER we are doing a series of knowledge sessions where several colleagues are doing a one-hour presentation about one or two package of their choice. We have already heard several very interesting presentations about DBMS_HPROF, DBMS_PARALLEL_EXECUTE, UTL_DBWS, UTL_TCP and DBMS_FGA. And this evening a colleague will do a presentation about DBMS_PREPROCESSOR and DBMS_WARNING, and I will do oneRob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.com1

OGh APEX day 2011

Wed, 2011-03-23 17:01
Yesterday I attended OGh's APEX day. Previous year was already pretty successful with 150 people attending. This year the maximum of 150 people was reached in only a few days, so we scaled up the event to a maximum of 250 people, and in the end we still had to disappoint several people. And this year we had several sponsors as well: Oracle, Ciber, Transfer Solutions and Itium. These must be signsRob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.com2

Open cursor paranoia

Thu, 2011-03-17 17:15
Most PL/SQL developers will likely have witnessed this phenomenon several times during their career. But only in other people's code, of course :-). I'm talking about PL/SQL code where every program unit ends like this:exceptionwhen others then if c%isopen then close c; end if; raise;end;where lines 3 to 6 are repeated for every cursor in the block above.Proponents of open cursor paranoia Rob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.com6

Runtime error ORA-01031: insufficient privileges

Tue, 2011-03-15 16:13
After a new version of software was installed in production, the end users reported a runtime error: ORA-01031: insufficient privileges, when selecting from a view. The developers of the code were investigating the problem and half way through, they asked me to have a look at the problem. I saw a function from schema3, which was used in a view in schema2, which was used by schema1. I had just Rob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.com1

Pages