Re: Java stored procedure call error: ORA-06576

On Nov 21, 8:22 am, "woongse" <woon..._at_gmail.com> wrote:
> And This is the result directlry after loadjava execution...
>
> SQL>  select * from user_objects where object_name like '%Oscar%';
>
> OBJECT_NAME
> ---------------------------------------------------------------------------­-----
> SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
> ------------------------------ ---------- --------------
> ------------------
> CREATED  LAST_DDL TIMESTAMP           STATUS  T G S
> -------- -------- ------------------- ------- - - -
> Oscar
>                                     29522                JAVA CLASS
> 06/11/21 06/11/21 2006-11-21:16:15:45 INVALID N N N
>
> Why does status is invlid?
>
> woongse 작성:
>
>
>
> > 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.- Hide quoted text -- Show quoted text -

Not being a java expert, so just asking... Is the Java code in your CLASSPATH?
Otherwise it won't compile and/or the pl/sql wrapper won't find it.

-- 
Sybrand Bakker
Senior Oracle DBA