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 -> Publishing Java Stored Procedure

Publishing Java Stored Procedure

From: rfk <rfk_at_exit109.com>
Date: Mon, 20 Nov 2000 21:06:14 -0500
Message-ID: <3A19D895.E54A01DF@exit109.com>

I have a little java stored procedure that takes 2 java Strings and concatenates them together and returns them (just a test program). I am having trouble publishing it and was looking for some help.

I have my code in FirstProcedure.java, on which I run 'loadjava' successfully:
> loadjava -user icd/icds_at_system -r -f -v -oci8 FirstProcedure.java
> initialization complete
> loading : FirstProcedure
> creating : FirstProcedure
> resolver :
> resolving : FirstProcedure
>

To check things:
> 1 select object_name, object_type, status, timestamp
> 2 from user_objects
> 3* where object_name = 'FirstProcedure';
>
> OBJECT_NAME
> ----------------------------------------------------------------------
 

> OBJECT_TYPE STATUS TIMESTAMP
> ------------------ ------- -------------------
> FirstProcedure
> JAVA CLASS VALID 2000-11-20:14:38:39
>
> FirstProcedure
> JAVA SOURCE VALID 2000-11-20:14:38:38
Now I try to publish it and get an error:

SQL> create or replace procedure rfkconcat (s1 varchar2, s2 varchar2)   2 as language java
  3 name 'FirstProcedure.Concat(java.lang.String, java.lang.String)   4 return java.lang.String';

Warning: Procedure created with compilation errors.

I don't understand what's the problem.
Any suggestions are greatly appreciated. Received on Mon Nov 20 2000 - 20:06:14 CST

Original text of this message

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