Cannot Deploy Java Stored Procedure from JDeveloper to Oracle XE Database

(Doc ID 401050.1)

Last updated on AUGUST 04, 2016

Applies to:

Oracle JDeveloper - Version 10.1.3.1.0 to 11.1.2.3.0 [Release Oracle10g to Oracle11g]
Information in this document applies to any platform.
***Checked for relevance on 06-Feb-2013***

Symptoms

Deploying a Java Stored Procedure from JDeveloper to Oracle XE fails with the following errors:

Invoking loadjava on connection 'newmartyconn' with arguments:
-order -resolve -thin
Error while creating class sp
ORA-06550: line 1, column 91:
PLS-00201: identifier 'NameFromLastDDL' must be declared
ORA-06550: line 1, column 85:
PL/SQL: Statement ignored

The following operations failed
class sp: creation (createFailed)
oracle.aurora.server.tools.loadjava.ToolsException: Failures occurred during processing
   at oracle.aurora.server.tools.loadjava.LoadJava.process(LoadJava.java:863)
   at oracle.jdeveloper.deploy.tools.OracleLoadjava.deploy(OracleLoadjava.java:116)
   at oracle.jdeveloper.deploy.tools.OracleLoadjava.deploy(OracleLoadjava.java:46)
   at oracle.jdevimpl.deploy.OracleDeployer.deploy(OracleDeployer.java:97)
   at oracle.jdevimpl.deploy.StoredProcHandler.doDeploy(StoredProcHandler.java:473)
   at oracle.jdevimpl.deploy.StoredProcHandler.doDeploy(StoredProcHandler.java:360)
   at oracle.jdevimpl.deploy.StoredProcHandler.doDeploy(StoredProcHandler.java:284)
   at oracle.jdevimpl.deploy.StoredProcProfileDt$Action$1.run(StoredProcProfileDt.java:383)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms