ORA-29531: no method %s in class %s

The code I have in PLSQL is as follows:

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "ConversorSQL" AS

package test;

import java.util.Calendar;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.io.FileReader;

import java.io.IOException;

public class ConversorSQL {

public static String runConversor(String tipoOperacion, String nombreTabla, String queryOpcional) {

return "Hola";

}

}

And then:

CREATE OR REPLACE FUNCTION f_conversorSQL(p_tipo VARCHAR2,

p_tabla VARCHAR2,

p_query VARCHAR2) RETURN VARCHAR2 IS LANGUAGE JAVA NAME 'test.ConversorSQL.runConversor(String, String, String) return String';

And I call it with:

SELECT f_conversorSQL( 'Hello there!',

'General Kenobi',

'You are a bold one')

FROM DUAL;

And I get the error in the title:

Error que empieza en la línea 1 del comando:

SELECT f_conversorSQL( 'Hello...

Read More »

By: StackOverFlow - Thursday, 8 November

Related Posts