Re: No errors shown after Compiled with errors message

Igor,

See my remarks below ...

> It's not a syntax error. '"' is used to preserve case-sensitivity in a
> name
> or when object name is a reserved word. Both are bad idea anyway. Some
> tools transparently
> enclose schema and object names into '"'. I bet you took your script
> out of one of them.

1. I do not think that enclosing words in double quotes is a bad idea. Because ANSI standard says that the number of reserved words can be increased in the future (that's what Oracle does from a version to version, and now there are around 600-700 reserved words, and your columns/package/function names may appear to be reserved in the future). The standard recommends quoting names in order to prevent the crossing with the reserved words in the future.
2. The script was written in DBA Studio 8.1.7 ! I didn't use reserved words, and the double quotes were added by the utility (Oracle utility). So, I think this is Oracle's feature/bug...
3. Thanks for the help. Now I see errors in the ALL_ERRORS table ... it's a pity that DBA Studio does not work with it ... Don't you know if Oracle pathced that problem ?

Regards,

Aleksey Burdakov Received on Fri Sep 28 2001 - 06:04:09 CDT