Re: sqldeveloper gives "compiler error" with good pl/sql

In message <1172085748.591945.208710_at_l53g2000cwa.googlegroups.com>, chunji08_at_gmail.com writes
>
>
>We are using stored procedures on Oracle, and everyday we need to
>export our tables, packages and sequences to some SQL files and upload
>them to a second database for our junit testing.
>
>We are using the Ant/sql to do the upload work, and using sqldeveloper
>to check the upload results. There are times that some package bodies
>are uplodaded, buy give us "compiler error", if I check through
>sqldeveloper.

There are some issues with SQLDeveloper and packages. What version of SQLDeveloper are you using?

One issue is that SQLDeveloper may compile with warnings enabled. If there are warnings it that will show as a compilation failure.

You should verify what is going on with SQL*Plus.

Try

select object_name,object_type,status from user_objects were status != 'VALID'; and

select * from user_errors;

-- 
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>