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: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 18 Nov 2004 18:03:07 +0100
Message-ID: <cng09j$o8f$1@news2.zwoll1.ov.home.nl>


Rauf Sarwar wrote:
> 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

Sorry, Rauf, the reply was meant more general, than just as reply for your solution.

-- 

Regards,
Frank van Bortel
Received on Thu Nov 18 2004 - 11:03:07 CST

Original text of this message

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