In message <1129159197.263554.212810_at_f14g2000cwb.googlegroups.com>,
alexis_at_globalmargin.com writes
>Im'm trying to create a new function using a Java class on my Oracle 8i
>server. I kept receiving error maessages, so I started to trim the
>class until now it's only a function returning the number 1.
<SNIP>
>
>select * from user_errors;
>
>NAME TYPE SEQUENCE LINE POSITION
>-------------- ------------ ---------- ---------- ----------
>TEXT
>--------------------------------------------
>MyClass JAVA CLASS 1 0 0
>ORA-29535: source requires recompilation
>
>And finally:
>
>show errors;
>
>No Errors
>
>
>What!!!!?????
As a side issue, show errors is broken in some versions of sql*plus (9.2
on windows for sure) don't rely on it.
--
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>
Received on Thu Oct 13 2005 - 04:06:11 CDT
