PL/SQL developer notes

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 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.

1 thought on “PL/SQL developer notes

Leave a Reply

Your email address will not be published.