5/17 PLS-00311: the declaration of "sqlExecution.checkUserExists(java.lang.String ,
[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