Oracle 10g package code.

[YSR]

After successfully compiling Oracle package, pl/sql developer is not retrieving the latest code. However, code seems to be existing on server as I was able to see from sql*plus(all_source ). I think the problem is in

 

[Marco Kalter]

Can you query the all_source view from within PL/SQL Developer and check if it shows the correct code? Can you also verify if the "Use DBA views is available" preference is enabled? In that case the dba_source view will be queried.

 

[YSR]

Checking 'Use DBA view if available' fixed the problem. Thankyou for your help.