Hi there,

I have never joined an Oracle forum before so hello.

I have just spent the last 9 years of my life working for Oracle Consulting UK. I am now contracting in the Cayman Islands.

I spent a lot of time writing a shell script and wondered if you'd like to see it. it really can save you a lot of time and is a nice cockpit to navigate around in.

works great for no database, core, or 11i (eBus)

tell me what you think:

http://www.oracle.me.uk

it only runs on unix (ksh) or bash with a very simple documented mod. I even coded it around pdksh's bugs (rightmost pipe not in current process).

Often, we want our PL/SQL code to output messages (using DBMS_OUTPUT) to debug a problem. This is mostly required during development, but may also come in handy if a program misbehaves in production. If the testing of your application is thorough, then you should never have an issue in the production environment. But, we all know that there are instances where we do want debug messages even in the production environment. Before Oracle 10g R2, this could not be done dynamically.