Exadata General (MOSC)

MOSC Banner

5/17 PLS-00311: the declaration of "sqlExecution.checkUserExists(java.lang.String ,

edited Feb 19, 2020 4:10AM in Exadata General (MOSC) 1 commentAnswered

[oracle@qxxxxx] $ loadjava -u upca@ExxxxxxxP_xxIN -r -v sqlExecution.java

Password:

********                                                                                                                  arguments: '-u' 'upca@ExxxxxxxP_xxIN -' '-r' '-v' 'sqlExecution.java'

dropped  : JAVA$CLASS$MD5$TABLE

creating : source sqlExecution

loading  : source sqlExecution

resolving: source sqlExecution

Classes Loaded: 0

Resources Loaded: 0

Sources Loaded: 1

Published Interfaces: 0

Classes generated: 0

Classes skipped: 0

Synonyms Created: 0

Errors: 0

[oracle@qqxxxxx1] $ sqlplus upca@ExxxxxxxP_xxIN

CREATE OR REPLACE PROCEDURE checkUserExists(

    dbServiceName IN VARCHAR2,

    mySql         IN VARCHAR2)

AS

  LANGUAGE JAVA NAME 'sqlExecution.checkUserExists(java.lang.String , java.lang.String ) return java.lang.String';

  /  2    3    4    5    6

Warning: Procedure created with compilation errors.

SQL> show error

Errors for PROCEDURE CHECKUSEREXISTS:

LINE/COL ERROR

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