ramon_at_conexus.net (Ramon F Herrera) wrote in message news:<c9bc36ff.0411141334.3499f5f5_at_posting.google.com>...
> Hello:
>
> I keep on getting error messages like the following:
>
> ------------------
> Record 7: Rejected - Error on table SHAWS.
> ORA-00001: unique constraint (DATABASE.CACHE) violated
> ORA-06512: at "DATABASE.SYNCSHAWS", line 21
> ORA-04088: error during execution of trigger 'DATABASE.SYNCSHAWS'
> -------------------
>
> However, when I take a look at the file that contains
> the SQL/PL code (in this case, a trigger) line 21 doesn't
> seem to be the right line. Is there some sort of magic
> delta number to be added/substracted?
> Perhaps I should remove the empty lines in my source code
> and count again?
>
> -Ramon
select text from all_source where name='SYNCSHAWS' and line=21 andtype='TRIGGER';
Received on Mon Nov 15 2004 - 09:32:59 CST
