Help - Strange errors version 10.0.5.1710

[Sgnao]

Since we installed version 10.0.5.1710 we have noticed two strange things, never happened before.

1) When compiling any object that has errors the program notifies the error but does not display what the error is. We must close the object and re-open it to see what the error was.

2) We have many of our Objects that have the "END;" statement followed by the name of the object itself. Sometimes the program substitutes the name after the "END;" statement with strange string such as P$TMP...

Has anyone ever seen these errors?

Thank you.

Marco

 

[Claus Pedersen]

1) sounds to me that you have too many warnings generated by Oracle. For some reason, Oracle can not show more than 20 warnings/errors and when you have 20+ warnings, you will not see any errors at all.
Go into Tools - Preferences -> Oracle -> Compiler -> PL/SQL Warnings and select Disabled for all exceptions and see if this helps.

2) Do you have Safe compilation turned on? (Tools - Preferences -> Window Types -> Safe compilation). This will generate temporary object names like you described.

Hope this will help you ...

 

[Sgnao]

Thanks for your reply, Claus.

I tried doing what you suggested, I'll let you know if that works.

On point 1 : I didn't have any entry enabled or disabled in Tools -> Preferences -> Oracle -> Compiler -> PL/SQL Warnings, so I inserted a "Disabled" line for All Warnings.

On point 2 : Yes, I had Safe Compilation turned on. I turned it off.

Thanks Again.

 

[Sgnao]

Claus, at first sight it all seems to be working fine.

Thank you very much.

Me and my colleagues appreciate your help very much!

 

[Claus Pedersen]

Glad to help