ORA-29531: no method checkUserExists in class sqlExecution
Hi All,
I have created java class and loaded in oracle database . With the help of java class PL sql function created but while executing th function it give below error.
ERROR at line 1:
ORA-29531: no method checkUserExists in class sqlExecution
ORA-06512: at "UPCA.CHECKUSEREXISTS", line 1
ORA-06512: at line 10
Code is given as below.
USER is "UPCA"
SQL>
SQL> CREATE OR REPLACE FUNCTION checkUserExists(
dbService IN VARCHAR2,
mySql IN VARCHAR2)
RETURN refcurpkg.refcur_t
IS
language java name 'sqlExecution.checkUserExists ( java.lang.String , java.lang.String ) return java.sql.ResultSet';
/
Function created.
SQL> show erro
No errors.
SQL> alter function checkUserExists compile;