Re: brain dead FOR LOOP gotcha

<snip>

> Of course, one might demand you reference the contents of the cursor
> appropriately? As in:
> dbms_output.put_line(n_count ||') '||r1.deptno);
>
> But you're right: a syntax error would have been nice.
> <gripe>Particularly from a piece of software that is smart-arsed
> enough to tell me I forgot the "from" when I mistype it as "form"
> but dumb enough not to correct it for me... (/gripe>

Hmmm... Consider this,

SQL> select 1 form dual;

select 1 form dual

ORA-00923: FROM keyword not found where expected

SQL> select 1 form from dual;

      FORM

         1

Do you want Oracle to automatically correct your spelling mistake in the first statement or (correctly) throw the error message that it cannot find FROM keyword. Maybe what you actually meant was the second statement... in which case Oracle was correct to point it out.

"Computer is as smart as the person working on it".

Regards
/Rauf Received on Fri May 06 2005 - 04:23:12 CDT