Re: there is an error in comments

From: Tim X <timx_at_nospam.dev.null>
Date: Wed, 23 Dec 2009 18:29:02 +1100
Message-ID: <87iqby408x.fsf_at_lion.rapttech.com.au>



hpuxrac <johnbhurley_at_sbcglobal.net> writes:

> On Dec 21, 7:45 am, Daneel Yaitskov <rtfm.rtfm.r..._at_gmail.com> wrote:
>
> snip
>
>> Hi List,
>>
>> I use Oracle 10 XE. I'm a student. When I wrote my lab then I had found
>> that Oracle alerts about an error for the line:
>>
>> call echo('dddddd'); -- comment
>>
>> But it processes normally this line without the comment:
>>
>> call echo('dddddd');
>>
>> The PL script is entirely:
>>
>> set serveroutput on;
>> create or replace  procedure echo(msg varchar ) as
>> begin
>>      dbms_output.put_line (msg);
>> end;
>> /
>>
>> call echo('dddddd'); -- comment
>> -- the end of script
>>
>> P.S. I have finished  study of Oracle and my opinion have been
>> apparently get negative. It doesn't concern Oracle's performance or
>> one's stability for overloads because I made only simple demo jobs.
>> Therefore I cannot say about it. But as Oracle's user say to work very
>> uncomfortable with Oracle.
>> PL translator works rather silent and doesn't show a precise line number
>> with an error.
>
> What a very fine piece of plsql!
>
> PLSQL has a debugger either in SQL Developer or a tool like Toad. I
> think you need to do some more labs perhaps!

or simply use sqlplus and type 'show errors'

Tim

>
> Have fun.
>

-- 
tcross (at) rapttech dot com dot au
Received on Wed Dec 23 2009 - 01:29:02 CST

Original text of this message