Re: debugging PL/SQL

From: GAG <ggilchr_at_worldweb.com>
Date: Sat, 10 Dec 1994 19:50:55 GMT
Message-ID: <D0M1sw.GK1_at_janus.border.com>


In article <3c86lt$n3o$1_at_mhadg.production.compuserve.com>, Frank Greene <74200.427_at_CompuServe.COM> says:
>
>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?

In SQL*Plus use the "show errors" command to get diagnostic/compile error information ... Received on Sat Dec 10 1994 - 20:50:55 CET

Original text of this message