Re: PL/SQL compilation error -- but no error?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 01 Mar 2001 07:34:50 +0100
Message-ID: <4brr9tko49pfeod5tsgbkmctoidva0cpsv@4ax.com>

On Thu, 01 Mar 2001 02:48:49 GMT, robertch_at_mindspring.com (Robert Chung) wrote:

>
>I am running into situations where PL/SQL code compilation fails with
>error, but when I do "show error", SQL*Plus returns no error. What
>should I do in such cases? Thank you in advance.
>
>

select * from user_errors where name = '<affected procedure/trigger>'

Hth

Sybrand Bakker, Oracle DBA Received on Thu Mar 01 2001 - 00:34:50 CST