If you have a program with parameters that have default values and you want the user to be able to change the default values of the parameters, without you having to change the value in the code, then put that data in a table. Why shouldn’t you just retrieve the data from the table in […]
Read moreCategory Archives: PL/SQL
Dutch Toad Usergroup…
On november 16th the Dutch Toad Usergroup will be holding a free seminar at the Amsterdam ArenA. If you want to register for this free event, follow this link. Steven Feuerstein will be giving a couple of sessions and my friend Alex Nuijten from AMIS will be performing the SQL and PL/SQL Quiz as a closing keynote, together […]
Read moreI love PL/SQL, and…
Like Alex has blogged on the AMIS Technology blog there is a site I want you all to visit. It’s one of Steven Feuerstein‘s Pet Peeves and it’s all about the PL/SQL language and what could be improved in it. I Love PL/SQL, and.. is a site where you can cast your vote on existing […]
Read moreTri-state boolean
All data types in the Oracle database implement the null value. Null is a very special value which means ‘Unknown’. That means that the value is really unknown. Null is not equal to null, because both are not known. Therefore you cannot compare them to each other. Even the boolean value has this null value […]
Read moreOracle errors…
I’m sure everybody ran into an error of some sort when using Oracle. Some errors are really obvious, you are trying to select a column that doesn’t exist, assigning a variable that hasn’t been declared, that kind of errors. But there are also errors that you don’t run into that often, maybe it’s even the […]
Read moreOpen cursors…
Today I came across a very strange problem in the code I am working on. The code raised a correct error, when executed the first time, but ran with no problems the second time. After a lot of debugging (even built a log package, hopefully so generic it will one day make it to my […]
Read moreBy position or by name…
In Oracle PL/SQL you have the possibility to call another program with parameters either by position or by name. Both have their pros and cons I think. Consider the betwnstr function (posted last time) and these calls (all have the same result): l_varchar := betwnstr(‘hello world’ , 3 , 5 , true); l_varchar := betwnstr(‘hello […]
Read moreAutomatic Syntax Highlighting…
In Windows Live Writer you can add Plugins that do certain things for you. One of those things is to add syntax highlighting to your postings. I found a Code Formatter for Windows Live Writer that does just about all you need, except of course for PL/SQL (and Delphi) code. Doing some more searching on […]
Read moreCrazy things in CodeGen…
While I was preparing for the presentation at Amis Academy about CodeGen I created an example to build an XML file based on data in the table. I started out with a script based on the (old) DEPT table (yes, I know, it’s very Oracle 7 to use these old tables).
Read moreMix and Match QDA and ‘old style PL/SQL’…
I am using the QDA (Quest Development Architecture) in a project that is running for about 10 years now. Instead of doing a ‘big-bang’ conversion I decided to use the QDA for new modules of the project that are being developed. I am using QDA packages for new tables. While we also do maintenance on […]
Read more