Re: DB Triggers Body Text
From: Peter Mapson <mapsonp_at_ois.com.au>
Date: 1996/05/17
Message-ID: <4nhgor$utr_at_opera.iinet.net.au>#1/1
Date: 1996/05/17
Message-ID: <4nhgor$utr_at_opera.iinet.net.au>#1/1
The trigger_body text is a long field. When you print a long field inside sql*plus, it only prints the first <n> characters of the long field (I can't remember what the default value of <n> is, and I'm writing this at home so I can't check the manual, but it's not very large).
Try entering:
set long <n>
where <n> is some larger value (say, 5000), before your run your query
against the view. You should see a lot more of your trigger body after
that.
Received on Fri May 17 1996 - 00:00:00 CEST