PL/SQL (MOSC)

MOSC Banner

ORA-29531: no method checkUserExists in class sqlExecution

edited Jan 29, 2020 12:14AM in PL/SQL (MOSC) 2 commentsAnswered

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;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center