Accessing Application Data only via PL/SQL Procedures?

Dear reader,

frequently i hear from different sources that a solid access to the Database must be based on a PL/SQL API - a technique wrapping Table access with PL/SQL. Currently i support a project developing a CRM system based on C#/.NET 2.0 and using an ORM (Object Relational Mapper) to store the content of the application. At the beginning of the project i was indeed sceptical about this approach. But on the long run i experienced it as a remarkable alternate approach interfacing a database for an application.

Click to read more ...



hi reader,

now this is my 3rd blog platform with increased possibilities.

  • sophisticated User Interface
  • GUI based style design
  • great search functionality
  • flexible page design
  • far more mature then wordpress

My old Blog is still accessible;

I like to talk about my daily experiences but also to share  some thoughts about the oracle server technology and last but not least about hihger level stuff like Design and Architecture of Systems and Applications.

I invite you to participate.


Karl Reitschuster



Welcome to Your Squarespace Website!


  • Editing Your New Site — You can get started editing right away by clicking the "login" link in your navigation bar. After logging in, you'll see a number of gray strips appear around your site that will let you interact with your site content.
  • Accessing Your Site Manager — When you're ready to re-configure your site at an even deeper level, you can click "Configure Website" in the upper-left of the top gray bar (that appears after logging in) in order to access your site manager.
  • Illustrated Guides / Videos / Help Manual — We have many illustrated guides, hundreds of FAQ answers, video tutorials, and more available within our support manual. It's a great place to get started if you're having trouble.
  • Support Requests — If you need help with anything, feel free to open a support ticket and ask a question.



Month ID generator

Hi reader,

if you have to deal with datawarehouses you need to implement dimension tables. A dimension could be the time dimension - a table of month Id’s for example to aggregate data per month. How to generate  such month id’s (YYYYMM)?

Click to read more ...


The LIKE Bind Parameter Dilemma (LBPD)

Updated on Thursday, October 30, 2008 at 8:50AM by Registered CommenterKarl Reitschuster

hi reader, everybody tells you to use bind variables (reduced parses) and that’s ok. But in some circumstances you get a lot of problems with it. Using bind variables with the LIKE operator could cause horrible performance even you index that column and you do not use a ‘%’ at the start of the searched string. The Optimizer has to calculate the cardinality of an operation. If cardinality changes the execution plan could change dramatically too.

Click to read more ...

Page 1 ... 6 7 8 9 10