Re: Altova's new "Database Spy"

From: Lee <leeh_at_panix.com>
Date: Fri, 07 Dec 2007 10:10:28 -0500
Message-ID: <fjbnpf$fua$1_at_reader1.panix.com>



I installed a trial copy of Altova's new "Databaee Spy" product (the continuing ODBC woes I encountered on the first hardware box I tried that with are under a separate thread)

When I finally got connected, I was surprised to see that whereas I CAN see all my stored procedures (stand alone stored procedures, I mean), I DONT see any of my packages. Not the specifications and not the bodies.

I could load a stand alone stored procedure into a "Sql Editor" (Didnt see anything called a "pl/sql Editor", could edit the code and even found a way to save the edited code on the local file system; but poke as a might, I couldnt find a way to compile the edited procedure so as to save the revised version back in the database.

There is an "execute" button on the GUI, but they really do mean Execute, not "compile".

Is the tool just plain not meant to be a code editor (After all the name "Spy" sort of implies "look but dont touch"), or is the free trial version cripple ware, or have I just not found the right little GUI whatsis, or what?

If its a "spy", well, where are the sequences and synonyms and a whole bunch of other database objects that dont show up on the "object explorer".

Has anyone else played around with the tool? Is it just not yet ready for prime time or have I got a dud version , or has the cleverness of the GUI interface fooled me good? Received on Fri Dec 07 2007 - 16:10:28 CET

Original text of this message