Re: debugging PL/SQL

In article <3c86lt$n3o$1_at_mhadg.production.compuserve.com>, Frank Greene <74200.427_at_CompuServe.COM> writes:
|> I have inherited a series of packages that were supposedly clean
|> compiles. However, when I attempt to start them, I almost always
|> get the &*&^%$ PPRCEDURE COMPILED WITH ERRORS message.
|>
|> Most of these packages are 10 to 15 pages long with no
|> documentation or even indenting. Hence, I am looking forward to
|> spending an agonizing period of time trying to debug / rebuild
|> these turkeys.
|>
|> Am I mising something fundamental? Surely there is some way to
|> get the package compiler to be a little more descriptive about
|> the nature of the error. If not, are there any kind of third
|> party packages that can be used?

Yep. Try 'show errors' from the SQL> prompt. Check out the SQL*Plus manual for more details. Received on Fri Dec 09 1994 - 02:47:05 CET