Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Java stored procedure call error: ORA-06576

Java stored procedure call error: ORA-06576

From: woongse <woongse_at_gmail.com>
Date: 20 Nov 2006 22:56:30 -0800
Message-ID: <1164092190.061423.68820@j44g2000cwa.googlegroups.com>


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
  3. sqlplus scott/tiger
  4. 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:56:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US