Home » Developer & Programmer » Reports & Discoverer » java.io.InvalidClassException: org.omg.CORBA.CompletionStatus; Local class
java.io.InvalidClassException: org.omg.CORBA.CompletionStatus; Local class [message #118362] Wed, 04 May 2005 12:50 Go to next message
dnguyen
Messages: 34
Registered: April 2005
Member
Hi,

I recently loaded a user-defined function into Oracle 10g Discoverer and although the function works (in SQL plus), when it is ran on Discoverer, I keep on getting this error message:

Error unmarshaling return; nested exception is:
java.io.InvalidClassException: org.omg.CORBA.CompletionStatus; Local class
not compatible: stream classdesc serialVersionUID=-9047319660881406859 local
class serialVersionUID=-645279251430243097

Although the function seems to work with very few rows and ends, when I use the function in a query that returns slightly larger data set I get the above error.

Below, is a copy of the function pl/sql code.

Basically, it takes the variable in a particular field that the user designates and matches it to the staff id in the staff table. If it matches, it'll return the entire staff name. If not, it should just return a NULL value.

CREATE OR REPLACE FUNCTION staff_full_name
(p_staff_id IN VARCHAR2)
RETURN VARCHAR2
AS
v_full_name VARCHAR2(100);

BEGIN
SELECT DISTINCT first_name || ' ' || LTRIM(mid_name || ' ') || last_name
INTO v_full_name
FROM staff st
WHERE st.id = p_staff_id
RETURN v_full_name;
EXCEPTION
WHEN no_data_found THEN
RETURN NULL;
WHEN too_many_rows THEN
RETURN NULL;
WHEN OTHERS THEN
RETURN NULL;
END staff_full_name;
/

Furthermore, I tried looking for solutions for this problem on google. However, all of them were java-based... a language I don;t know to use and also, don;t have the priviledges if I had the knowledge.

If someone knows how to change this function so that it'll work in discoverer then that'd be great.

Also, I tried uploading this simple function (taking advice from a helpful person on the SQL newbie forum):

CREATE FUNCTION test_function
RETURN VARCHAR2
AS
BEGIN
RETURN 'OK';
END;

and it still returned the same error message (although again it worked well in sql plus).

So, I figure it's something I don;t know about how you're supposed to create functions for discoverer. I tried looking on the web but found no clearly stated requirements for Oracle 10g Discoverer.

Okay, this is long but hopefully, I provided enough information.
Re: java.io.InvalidClassException: org.omg.CORBA.CompletionStatus; Local class [message #118384 is a reply to message #118362] Wed, 04 May 2005 16:36 Go to previous messageGo to next message
dnguyen
Messages: 34
Registered: April 2005
Member
Also, as reference to what I mentioned concerning the java solution on the net:

http://forum.java.sun.com/thread.jspa?threadID=459268&messageID=2101228

Re: java.io.InvalidClassException: org.omg.CORBA.CompletionStatus; Local class [message #521432 is a reply to message #118384] Mon, 29 August 2011 18:08 Go to previous message
nagas
Messages: 1
Registered: August 2011
Location: hyd
Junior Member
Hi .

I am using Discoverer 10g . i am also getting the exact error that you are getting . we didnot change anything since years .

Please let me know how to elimate it . its urgent . pls help

Thanks
Naga
Previous Topic: Getting incompatible frequency fora formula column :-(
Next Topic: REPORT ERROR 103
Goto Forum:
  


Current Time: Mon Mar 30 02:02:46 CDT 2020