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.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.htmlReceived on Thu Nov 18 2004 - 16:13:40 CST
![]() |
![]() |