We are using a clever feature or oracle 11gr2 called edition-based redefinitions.

This means each stored proc and view looks different depending on the edition you set in the session. There are multiple versions of each of these objects.

I'm trying to find a DB client (for browsing data and running SQL) which supports this properly - ie can show me visually the different editions, etc.

DBVisualizer doesn't seem to do this. Here's an example:

my program code (which explicitly sets an edition) says: ORA-04063: package body "MATT2.ER_BATCH_SUB_PKG" has errors

But when looking in dbvisualizer to the 'invalid objects' view, I see nothing.

  • I would expect Oracle's SQL Developer to support that. – a_horse_with_no_name Mar 27 '14 at 11:33
  • even SQLPLUS supports editions. My guess is you have to alter your user session to a specific edition and then you will be able to see errors for the code in that edition. I have not played with editions, but this is just a guess. – Raj Apr 1 '14 at 19:01
  • @a_horse_with_no_name thanks yes you're right, it does. – mdarwin Apr 2 '14 at 9:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.