Re: Java stored procedure call error: ORA-06576

I'm using ORACLE v9.2.0

woongse ÀÛ¼º:

> 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 - 00:58:30 CST