Re: what means a line of <> in PL/SQL

Yes it's a loop label like you and Andy say. I found <> in the html-format-object report generated by DBA-studio and at it seems that the inner brackets incl. label name distinguish somehow at generation of report. The same line in schema-viewer of DBA-studio looks like

<<i_loop1>>

Thanks,
Peter

"Brian Tkatch" <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK> schrieb im Newsbeitrag news:3c4311dd.553519500_at_news.alt.net...
> On Mon, 14 Jan 2002 15:15:20 +0100, "Peter K" <P.Kloo_at_mylius.com>
> wrote:
>
> >Hi,
> >
> >in a sqlserver -> oracle 8 migrated stored procedure i can read
> >...
> >end if;
> ><>
> >while ....
> >...
> >
> >what's the meaning of <> (guess it is not the relational operator)
> >
> >Cheers,
> >Peter
>
> Is that exactly what it says?
>
> In Oracle, loops can be labeled.
>
> <<This_Is_A_Loop_Label>>
> LOOP
> NULL;
> END LOOP This_Is_A_Loop_Label;
>
> It is usually unneeded, thought is may make the code look nice.
> However, if you need to exit an out loop, it is essential.
>
> Brian
Received on Tue Jan 15 2002 - 02:55:22 CST