Recently in Programming Category

Fair warning: this entry will make little or no sense to you unless you work in UCS and do PL/SQL programming.

I've made a change to wou_util.wou_ldap.vnum_to_uid, specifically to the way it deals with V-numbers that are attached to multiple user accounts. Before, if you passed a usertype as the optional second parameter, and it couldn't find a uid matching that type, it would still return a uid if it found one of another type that had the given V-number.

As of today, passing the second parameter will make the function behave more strictly; if a user account of the given type cannot be found, the function will return zero even if there is a user account or another type that has the given V-number.

In other words, passing a usertype to vnum_to_uid() means you want a matching uid only if it also matches the given usertype.

If you only pass a single parameter, the function will behave exactly as before; if multiple accounts are found, it will return the last one found. This is usually the most recently created account, but don't rely on that always being true.

Oh, and one other note: there is a new usertype, "Alumnus". All LDAP accounts of people who have graduated from WOU have this type. It is possible for someone to have both Student and Alumnus, for example if they graduated and then returned for a Masters program.

One of the big projects I'm working on right now is user account renaming. All of a sudden, this term we've got a bunch of requests from people wanting to change their usernames; usually either because they got married and changed their name, or because it wasn't spelled right in the first place. We rarely ever got these before, and the standard answer used to be "We can delete your account and make you a new one, and if that's not acceptable, you'll have to live with your current username."

Now, though, we've got a process that can actually change a username. This is harder than you might think; a username is stored in a lot of places, and affects a lot of things under the hood of several servers, so there are lots of t's to cross and i's to dot.

For instance, changing your username means changing the location where your personal files are stored, which in turn means that several settings in your blog have to be changed, along with (of course) moving your files. We have to change your email address, the location where your messages are stored, any email aliases you may have, any email list memberships. We aren't even going to try looking in everybody else's address books to see if your old email address is in there. It's bad enough that, because of the way the Communications Express address book is stored, we have to make a behind-the-scenes change to every address record in it.

The real sticking point of all this is your online calendar, also part of Communications Express. Because Sun originally bought the calendar server from some other company, it uses a database that's pretty different from other Sun products. Partially because calendars are so interlinked with each other, and also because of some fundamental choices made by that original company, a calendar simply can't be renamed without shutting down the calendar server and rebuilding the entire database of all calendars, just in case they have any links with your calendar. I've pretty much given up on being able to do that with an automatic process. There's just too many things that can go wrong.

The good news is that almost everything else is now changeable, and most of it is automated. If you need your name changed, contact the Service Request Desk and they'll get it to me.

OK, so it's been a while. Seeing as I'm supposed to be the blog server admin and all, I suppose I should actually post a blog entry once in a while.

From now on, I'm not going to be aiming all my blog posts at the general WOU community; some will, but there will probably be more stuff for the UCS folks in particular, especially the other admins and programmers.

So, for the PL/SQL programmers, a couple things about PL/SQL developer.

In case you've been wondering how to get the HTML documentation installed, I finally figured it out. I had to download it from Oracle, but it's now on the T: drive in the PL/SQL Developer folder, under the name ora9i_htmldocs.zip. Here's how to install it:

1. Unzip the file to some appropriate place like C:/orant/htmldocs. This took a while on my machine.


2. In PL/SQL Developer, go to the Help menu and select HTML Manuals.


3. You should see a dialog box, with a textbox near the top. It will probably have your local oracle home in it; change it to the folder where you unzipped the HTML docs.


4. Click Build. On my machine, it showed progress, then appeared to hang for a couple of minutes, but then completed successfully.


5. On completion you should see a long list of book titles with checkboxes. Scroll down to verify that the following are checked:
   
   
   
   • Oracle 9i Database Error Messages
   
   
   • Oracle 9i SQL Reference Release 2 (9.2)
   
   
   • PL/SQL User's Guide and Reference
   
   


6. Click the Apply button


7. That should be it! If all went well, you should now be able to use the Search tab in the HTML Manuals dialog box, and the Help buttons on error messages should now take you to actual help. (Since this is Oracle we're talking about, though, the help isn't always especially helpful.)

Another thing related to PL/SQL Developer 7.11: Has anyone else noticed weird characters in the code help dropdown menus? Dale and Michael Ellis clued me into this. I can't reliably reproduce it and am wondering if anybody else can.