Ora-29540 When Executing a Java Stored Procedure (Doc ID 376879.1)

Last updated on MARCH 14, 2025

Applies to:

Symptoms

Getting "ORA-29540: class TestInsert does not exist" error when referencing a java stored procedure:

TestInsert.java
--------------------
package TestInsert;
import java.sql.*;
public class TestInsert
{
public static void main(String[] args)
throws ClassNotFoundException, SQLException
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@<ipaddress>:<portnumber>:EMB920W6", "scott", "tiger");
Statement stmt = conn.createStatement();
int numRows = stmt.executeUpdate("INSERT INTO test VALUES ('hello world')");
conn.close();
}
}

SQL> CREATE OR REPLACE PROCEDURE "TEST_PROC" as language java name 'TestInsert.main(java.lang.String[])';
2 /

Procedure created.

SQL> EXEC TEST_PROC
BEGIN TEST_PROC; END;

*
ERROR at line 1:
ORA-29540: class TestInsert does not exist
ORA-06512: at "SCOTT.TEST_PROC", line 0
ORA-06512: at line 1

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.