Logging did it, thanks.
The ORACLE_HOME environment variable was some how changed to nothing. Pointing it to the x86 client makes pl/sql dev work.
But what should it be, now having 2 clients?
Now I have both x64 and x86 oracle client installed. x64 works fine, and on the x86 the oracle net manager is testing connection ok. But using PL/SQL Dev, I am getting the "ORA-12154 TNS:could not resolve service name". Tried everything known to mankind related to this error message. Normally I...
I am aware of that PL/SQL Dev cannot use a x64 oracle client, due to beeing a 32 bit application it self.
However, 64 bit clients are getting more and more common in developer teams due to heavy memory requirements.
I am not too fond of installing both 32 and 64 bit oracle clients on same...
Well, it seems like you are all ahead of me!
To get it clear: We are talking about comparing schemas, right? Does it go any further than doing data comparing of tables with same name and definition?
In any case - I'm looking forward to see it!
Perform regression tests using PL/SQL Dev.
I am currently doing application regression test by comparing complete images of tables after a test run. I do this be either:
- Using
When repeatingly using import and export tables it would be really neat if one could save the definition of the import and export.
The reason is that I use these features for an easy regression test of my applications, by comparing complete images of tables. This often includes several tables...