Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Where is line 21? ++ USER_TRIGGERS vs USER_SOURCE
rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0411170146.7776ca86_at_posting.google.com>...
> Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<cndi90$moj$1_at_news4.zwoll1.ov.home.nl>...
> > Rauf Sarwar wrote:
> >
> > [snip]
> > >
> > > SQL> select text from user_source where name = 'FOO' and line = 6;
> > >
> > > TEXT
> > > --------------------------------------------------------------------------------
> > > dbms_output.put_line('This is line 6 NOT OK';
> > >
> >
> > What's wrong with L6?
> > SQL*Plus reference:
> > L[IST] [ n | n m | n * | n LAST | * | * n | * LAST | LAST]
>
> Nothing wrong with it.. I use it all the time. My post was in response
> to user_source usage as discussed by others in this thread... plus
> this command is relevant to SQL*Plus only.
>
> Regards
> /Rauf
Isn't L6 missing a trailing parenthesis?
jg
-- @home.com is bogus. "When you're my age, there's two ways to find out if you're still alive. One is to feel your pulse. The other is to see if you're having a fight with somebody. Though I shouldn't say this, it's satisfying to be the center of some kind of storm. It's also a way of magnifying my ideas." - Tom WolfeReceived on Wed Nov 17 2004 - 15:05:40 CST