Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Where is line 21? ++ USER_TRIGGERS vs USER_SOURCE

Re: Where is line 21? ++ USER_TRIGGERS vs USER_SOURCE

From: Joel Garry <joel-garry_at_home.com>
Date: 17 Nov 2004 13:05:40 -0800
Message-ID: <91884734.0411171305.77572d40@posting.google.com>


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 Wolfe
Received on Wed Nov 17 2004 - 15:05:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US