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

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 Received on Thu Feb 22 2007 - 16:11:01 CST