OK, I’ll put my toe in. I’m a long-time JUnit user who considers TDD the best approach to code development, but who never had a reason before to need a PL/SQL unit tester.
I’m trying to get QCTO working on Oracle 10 Express. I’ve chosen this method to get started because all the components would be under my control and I wouldn’t have to get DBA assistance to get things running. Or so I thought.
I’ve downloaded 10xe from Oracle’s website and installed it, run it, tried a few SQL statements to see if it’s alive and it seems to be. I’ve created a new user (qcto) and granted him all available privileges.
I’ve downloaded the latest (as of 9 Nov) QCTO and run the installation several times (QuestCodeTester1255). The installation fails consistently if I try to create a new repository but finishes if I allow the existing repository to be updated. I’m not sure what this means.
At this point in the installation process, I see a QCTO dashboard appear along with a login dialog. I enter the username (qcto) and its password plus the database type of XE and hit OK. The dialog diappears and a tiny dialog with a single OK button shows up. I hit OK again and the login dialog reappears. I can enter any of the XE users I’ve created, including system, and the appropriate password and never get out of the login dialog-tiny dialog loop.
I’m stumped. I’ve read the papers and watched the presentations and would really like to get QCTO working, since it seems very slick and it solves a problem I’m facing. However, as things stand, I’m blocked from doing anything useful.
Any suggestions would be appreciated.