Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Show Errors on Oracle PL/SQL compile?
Show Errors on Oracle PL/SQL compile? [message #1039219] Thu, 11 April 2013 23:09 Go to next message
Kevin Rooney is currently offline Kevin RooneyFriend
Messages: 2
Registered: April 2013
Junior Member
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?


Re: Show Errors on Oracle PL/SQL compile? [message #1777839 is a reply to message #1039219] Tue, 05 December 2017 08:52 Go to previous message
sarah john is currently offline sarah johnFriend
Messages: 2
Registered: December 2017
Junior Member
Hello Kevin, You can solve this error for Oracle PlSql( 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

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

Current Time: Mon Jan 25 09:02:33 GMT 2021

Powered by FUDForum. Page generated in 0.01683 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top