Re: Trigger

From: Peter H. Larsen <petlars_at_pipmail.dknet.dk>
Date: 1997/02/12
Message-ID: <01bc1887$8af820e0$03000181@phl>#1/1

Hi,
SHOW errors doesn't always work as one except it too. To be 100% sure, select * from user_errors where name = 'whatever' or just let out the condition.

Further more, it's never recommended to have large trigger-bodyes. Make a procedure or a function, and let the trigger call this. Triggers are stored in LONGs using the dictionary, and finding errors using linenumbers simply isn't done, besides from manual counting them.

-- 
// Complete Data Service
// Peter H. Larsen
// petlars_at_pip.dknet.dk

Ed Prochak <edprochak_at_interfacefamily.com> skrev i artiklen
<32FFE6CE.AAD_at_interfacefamily.com>...


> > How I can show errors, if I try with 'show error' Oracle return 'No

 error'


> 

> isn't it 

>           SHOW ERRORS

> ?

> 

> > 

> > Thanks

> > Andrea Savino

> > A.Savino_at_agora.stm.it

> 

> You are welcome.

> 

>  Ed Prochak

> 

> -- 

> I shall be telling this with a sigh    | email:

> Somewhere ages and ages hence:         | edprochak_at_interfacefamily.com

> Two roads diverged in a wood, and I--  |

> I took the one less travelled by,      |

> and that has made all the difference. --Robert Frost

>

Received on Wed Feb 12 1997 - 00:00:00 CST