Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to call "execute dbms_utility" using native query?

ebitarJul 27 2015 — edited Aug 30 2016

HI,

I need to compile my invalid object using JPA.

In My EJB i have a method that does that:

	Query query = em.createNativeQuery("execute dbms_utility.compile_schema('CGBDEV8', false)");
	int irslt = query.executeUpdate();

But the executeUpdate is failing.

Can you provide me with a solution on how it can be done.

Thank you in advance

Emile

This post has been answered by kdario on Jul 30 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 27 2015

Added on Jul 27 2015

#application-development-in-java, #jdeveloper-and-adf

4 comments

276 views