Re: Looking at view creation ?

AlBeRt tHe GoD wrote:
>
> Which table can I read to get the full source for a
> trigger and view, because when I query the user_views and
> user_triggers I do not get the full source.Hi,
You can set long to a value that is large (ie, set long 10000) You will also have to set arraysize to 1 (set arraysize 1) this way the description field for triggers or text field for views can be displayed or captured.
user_views also has a field text_length that tells how large the text field is.

Hope this helps.

Dick Allie - dallie_at_ionet.net Received on Fri May 02 1997 - 00:00:00 CDT