ORA-29506 when compiling java

From: daniel.ostertag@xxxxxxxxxx
Date: Mon, 06 Aug 2007 11:53:51 -0700

We have an Oracle 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

.

Prev by Date: Re: Examples of real usage of outer joins?
Next by Date: Re: jdbc and prepared statement compilation
Previous by thread: Examples of real usage of outer joins?
Next by thread: Re: jdbc and prepared statement compilation
Index(es):
- Date
- Thread

Relevant Pages

ORA-29506 when compiling java
... 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 ...
(comp.databases.oracle.misc)
Re: ORA-29506 when compiling java
... CREATE OR REPLACE AND COMPILE NOFORCE JAVA SOURCE NAMED Model_Scorer_1 ... USING CLOB SELECT SOURCE FROM PROSPECT_MODEL WHERE ID = ... The USING clause implicitly supplies the keyword SELECT. ...
(comp.databases.oracle.misc)