Re: Debugging SPs

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 07 Oct 2002 22:56:49 GMT
Message-ID: <3DA21112.CD308D84@exesolutions.com>

"William F. O'Neill" wrote:

> Using Powerbuilder 6.5 & Oracle 8.0.5 on WINNT. Keep getting an Oracle
> error, eg. ORA-01007(variable not found in Select) error. My SP runs 19
> pages, and am having a difficult time trying to resolve this error. Anyone
> know the best way to debug a SP?

Try SQL*Plus. It will give you the line number in your code on which the error is found.

Try SQL Navigator or TOAD and it gets even easier.

Daniel Morgan Received on Mon Oct 07 2002 - 17:56:49 CDT