Re: Yet another funny PL/SQL parser "feature"

FC wrote:

> Hello folks,
> here is another interesting parser feature of 8.1.7.0.0.
>
> I bet you don't have any table called <ohmygoodness> in your db, but the
> following procedure will still compile without a hitch.
> Luckily enough, it will raise an exception at run time, unless you do have a
> table with such name.
>
> ----
> Procedure have_fun
> is
> begin
> lock table ohmygoodness in share mode;
> End;
> ----
>
> Bye,
> Flavio

Seems it will do it with anything provided. The following is perfectly legal too in 8.1.7.

CREATE OR REPLACE PROCEDURE xxx IS

BEGIN
  LOCK TABLE thisisabloodyjoke IN SHARE MODE; END;
/

Daniel Morgan Received on Fri Aug 02 2002 - 15:34:41 CDT