Re: Viewing source code of a trigger

From: <TOnions_at_attrs.uk.att.com>
Date: Wed, 02 Sep 1998 11:32:30 GMT
Message-ID: <6sjace$7lm$1@nnrp1.dejanews.com>

If you are using SQL*Plus remember to do:

SET LONG 1000 or something appropriate as trigger code is stored in a LONG column which SQL*Plus only shows the first few bytes of by default.

In article <6sff27$r25_at_bgtnsc03.worldnet.att.net>, "Madhu Cherukuri" <madhuc_at_hotmail.com> wrote:
> Look at SYS.DBA_TRIGGERS
> You should find code in that table
>
> Madhu Cherukuri
>
> Robert Chung wrote in message <35eb1354.33711214_at_news.mindspring.com>...
> >
> >I need to take a look at the source code of a particular trigger that
> >is slowing down our database big time. I am trying to see the code
> >using TRIGGER$ data dictionary view. However, this table displays
> >only a couple of lines of the code and does not let you see the rest
> >of the code. Is there some other way to see the code? (possibly with
> >other data dictionary view?) Thank you in advance.
> >
> >
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 02 1998 - 06:32:30 CDT