1 March 2012

how to solve problem with "RA-20102: Application collection PLSQL_OBJECT_SOURCE does not exist "?

how to solve problem with RA-20102: Application collection PLSQL_OBJECT_SOURCE does not exist ?

It many reason, why this error appear.Most people discribe this "It appears for no reasons and diseapear somehow". I was this unluckly person to enjoying lots of swearing on how Oracle Database Express Edition is a crap and etc.
Anyway, if you see above problem i found that problem appear because:

If you edit sql file in STS(Eclipse) ,then make sure that your connection profile is set to Oracle_10 (or similar) [it cause problems many time,because STS for fun ,changes this connection profile randomly every single time when i open sql file in STS.]

Another problem that cause above error was problem with ... encoding... in my case it works with ANSI only.(When i uploaded script(UTF-8) and choose UTF-8 (i had above error message or upsidedown question mark as first character)

It solve my problems ....

 Btw.  After IE(web browser) and Eclipse(IDE) ... Oracle(DB) should be proud ,because I join them to my list of mortal enemies in software development.