ORA-29506 when compiling java

From: Dan <daniel.ostertag_at_visaer.com>
Date: Mon, 06 Aug 2007 11:52:42 -0700
Message-ID: <1186426362.630474.5060@d55g2000hsg.googlegroups.com>

I have a 9i Release 1 database that is getting the following error when compiling java functions.

---

CREATE OR REPLACE AND COMPILE NOFORCE JAVA SOURCE NAMED Model_Scorer_1 USING CLOB SELECT SOURCE FROM PROSPECT_MODEL WHERE ID = '40288114141fa66201141fa670b20001';  

*
ERROR at line 1:

ORA-29506: invalid query derived from USING clause
ORA-00936: missing expression
-----------------

I looked into this error and a site recommended changing any auto space management tablespaces to manually managed for 9.1. I already have the TS's as manually managed, so this isn't the problem.

Does anyone have any ideas? Can 9.1 handle CLOB's at all? Is there a way I can fix this in 9.1 (I know I should upgrade...)?

Thanks,
Dan Received on Mon Aug 06 2007 - 13:52:42 CDT