Eclipse Community Forums: DTP » Show Errors on Oracle PL/SQL compile?

Home » Eclipse Projects » DTP » Show Errors on Oracle PL/SQL compile?

Show Errors on Oracle PL/SQL compile? [message #1039219]

Thu, 11 April 2013 19:09

Eclipse User

Hello, all.

I'm trying to use eclipse and the data perspective to connect to an Oracle database and compile PL/SQL. (RSA v7.5.5.5 iFix001...I believe this is about v 3.2 of eclipse...I'm stuck with an older version due to my company forcing it on me).

When I get compilation errors for the PL/SQL code, I am unable to see the compiler errors via the normal oracle "show errors" statement. (it claims it's invalid sql)

Anybody have any idea how to get the oracle errors using eclipse in this way?

Thanks,

Kevin

Re: Show Errors on Oracle PL/SQL compile? [message #1777839 is a reply to message #1039219]

Tue, 05 December 2017 03:52

Eclipse User

Hello Kevin, You can solve this error for Oracle PlSql(mindmajix.com) Try this answer let you know that you can also use:

alter package your_package_name_here compile package;

alter package your_package_name_here compile body;
then if warning was shown, you can use the below script to check the error and which lines it resides in:

show errors package your_package_name_here;
--> this shows the errors within the package itself

show errors package body your_package_name_here;
--> this shows the errors within the package body

I hope this will helps you

Regards
Sarahjohn

Previous Topic:	Oxygen DTP can't edit table on mySQL
Next Topic:	How to execute driver XML ODA assemblage?

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 14 22:10:08 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter