Toad definitely has its uses. Its hard to beat that nice step-through debugger for procedures. It has some other nice features. Its just kind of a heavyweight tool in my book. For a nice easy to use, lightweight tool you guys really should look at golden. I use it, but I have no financial interest in it at all. I have just found it to be one of the nicest tools out there, quick, and for clean interfaces its hard to beat. Yeah, I know, I sound like a salesman, but I have been using it for about 10 years now, and have yet to find anything to match it for general dba use. On Wed, Jul 18, 2012 at 11:04 AM, Johan Muller <johan.muller@xxxxxxxxx>wrote: > Ultra edit (syntax highlighting) for code; Toad for step thru > debugging showing how variables change or if your code sucks l(like > mine) where it drops out for whatever damage you inflict (bad arrays, > poor cursor handling etc). > > The pl/sql message that code is compiled is not entirely true (in my > case bad code is bad code) and any logic bombs etc. is purely my > fault. > > Take Steven F. class or get his book on PL/SQL. I found a used copy > on addall.com for 3.95 plus shipping: > > > TITLE: Oracle Pl/Sql Programming, Third Edition > by Steven Feuerstein > ISBN: 0596-00381-1 > ISBN 13: 978-0596-00381-4 > Publisher: O'Reilly Media > Publish Date: 2002-09-30 > Binding: Paperback > List Price: USD 54.95 > > > Johan Muller > Oracle DBA (official Orasaurus) > 817 | 715 | 4813 or 817 | 247 | 0260 fax 817 | 523 | 4942 > Text : 8177154813@xxxxxxxxxxx > -- > //www.freelists.org/webpage/oracle-l > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- //www.freelists.org/webpage/oracle-l