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: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 17 Nov 2004 01:46:52 -0800
Message-ID: <92eeeff0.0411170146.7776ca86@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 Received on Wed Nov 17 2004 - 03:46:52 CST

Original text of this message

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