Re: Java stored procedure call error: ORA-06576

From: woongse <woongse_at_gmail.com>
Date: 20 Nov 2006 23:22:07 -0800
Message-ID: <1164093727.002555.67090@m73g2000cwd.googlegroups.com>

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.
Received on Tue Nov 21 2006 - 01:22:07 CST