Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Java stored procedure call error: ORA-06576
Yes, I have set CLASSPATH variable and user javac in oracle.
sybrandb ÀÛ¼º:
> 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 -
>