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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Thu, 11 April 2013 23:09

Kevin Rooney

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?

Thanks,

Kevin

Report message to a moderator

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

Tue, 05 December 2017 08:52

sarah john

Messages: 2
Registered: December 2017

Junior Member

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:09:21 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter