Re: Recompile invalid packages

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:<aeFqb.22853$I74.8308_at_news01.roc.ny>...
> I don't know why Oracle does not fix this bug in sqlplus
> wherein if # is the 1st character in the line .. it will go ahead
> and happily execute the rest of the statement (and throw error
> if its not a valid statement).
>
> Its been there for so long now!

Equally unpleasant is /* immediately followed by your SQL (tested with 9.2.0.1 sqlplus for Windows):

SQL> create table t (a number);

Table created.

SQL> insert into t values (123);

1 row created.

SQL> /*select * from t;

1 row created.

SQL> select * from t;

         A

       123
       123

except in this case the SQL following /* (with no space) is ignored and whatever was run last time is run.

Yong Huang Received on Fri Nov 07 2003 - 08:51:34 CST