Re: Java stored procedure call error: ORA-06576

Hi,

step#2 Which JDK are you using to compile the Java class? The Java VM in 9.2 is 1.3.x compatible. Alternatively you can load the source and compile directly in the database.

step# 5 Try "select oscar_quote from dual;"

See more details in chapter 3 of my book. Kuassi

woongse wrote:
> I'm a new to ORACLE DBMS.
> Now, I'm trying to user java stored procedure.
>
> According to Oracle document, I followed the java call sp procedure.
> But there error happend.. always....
>
> ORA-06576: not a valid function or procedure name
>
> Please Help me ........
>
> PS.
>
> To replay.....
>
> 1. vi Oscar.java
> public class Oscar {
> // return a quotation from Oscar Wilde
> public static String quote() {
> return "I can resist everything except temptation.";
> }
> }
>
> 2. javac Oscar.java
> 3 loadjava -verbose -u scott/tiger Oscar.class
> 4. sqlplus scott/tiger
> 5. SQL>CREATE or replace FUNCTION oscar_quote RETURN VARCHAR2
> AS LANGUAGE JAVA
> NAME 'Oscar.quote() return java.lang.String';
> 5 SQL> call oscar_quote()
>
> error happened.
Received on Tue Nov 21 2006 - 11:33:43 CST