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

In message <1172182261.720646.159420_at_m58g2000cwm.googlegroups.com>, chunji08_at_gmail.com writes
>On Feb 22, 1:29 am, Jim Smith <usene..._at_ponder-stibbons.com> wrote:
>> In message <1172085748.591945.208..._at_l53g2000cwa.googlegroups.com>,
>> chunj..._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?
>
>The SqlDeveloper that I am using is 1.1.0.23.
>>
>> 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;
>>
>I will give a try.
>
>In the mean time, I am still try to create a case to show the error I
>am getting. Thanks.
>
>
>
>Charlie
>
>
>
>
>

There are a couple of later releases (latest is 1.1.1.25.14) and some bugs related to PL/SQL have been fixed.

If you do pin down a specific problem with SQLDeveloper, post it to the forum on OTN <http://forums.oracle.com/forums/forum.jspa?forumID=260>.

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