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: 18 Nov 2004 14:13:40 -0800
Message-ID: <91884734.0411181413.5ee8e229@posting.google.com>


rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0411180146.776ac84d_at_posting.google.com>...
> joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0411171305.77572d40_at_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';
> > > > >
> > > >
> >
> > Isn't L6 missing a trailing parenthesis?
> >
>
> Joel,
>
> Yes it is. Normally I would thank you for correcting my mistake but
> this time I left the paren out on purpose "This is line 6 NOT OK" to
> show the error message. Please read couple of my previous posts in
> this thread.

D'Oh! My mistake in misreading Frank's answer as asking what was wrong with line 6 rather than stating the command L6 (which I never use because I habitually go straight into the editor to fix things right away).

jg

--
@home.com is bogus.
You think you get spammed:
http://www.news.com.au/common/story_page/0,4057,11428244%255E1702,00.html
Received on Thu Nov 18 2004 - 16:13:40 CST

Original text of this message

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