This content has been marked as final. Show 3 replies
(Be sure to include versions of relevant components, e.g. OS, Java, DB, etc.)
I haven't worked with object types, but have seen the 03113/07445 combination with java stored procs in at least one other occasion, but I don't believe that would apply here (the developer was using an older procedure call that couldn't handle LOBs larger then 4K).
But some things you may wish to check out/try:
1. Be sure your using the proper version of java (possibly 1.4.2).
2. Make sure the database has enough memory assigned to java_pool_size (>= 20M).
3. Be sure JVM is installed properly. (Reinstalling wouldn't hurt, I've had to reinstall various system packages on occasion to ge them working correctly. This will ensure not only that everything is installed, but permissions are correct.) The Java Developer's Guide should explain how to do this. However, in a nutshell:
Just places to start....
Apologies for not stating that information, Steve. Was a bit naughty of me! I guess the reason I didn't was because I just wanted to hear if anyone else running Oracle on Mac received such errors when executing the Java stored proc demos (specifically, the execution of PointRuntime.jDistance). Nevertheless, here's the relevant info from the trace file:
Dump file /Users/oracle/admin/sandbox/udump/sandbox_ora_1861.trcAs for the Java version, according to the readme file in the javavm directory, I am running 1.4.1:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
ORACLE_HOME = /Users/oracle/product/10.1.0/db
System name: Darwin
Node name: maczilla.local
Version: Darwin Kernel Version 8.3.0: Mon Oct 3 20:04:04 PDT 2005; root:xnu-792.6.22.obj~2/RELEASE_PPC
Machine: Power Macintosh
Instance name: sandbox
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 1861, image: email@example.com
1.5 Java Compatibility
This release has been thoroughly tested with Sun's Java Compatibility
Kit for the JDK 1.4.1. Oracle is committed to OracleJVM keeping pace
with Java and other Internet standards.
I know there are not as many version options for OS X as for AIX, but sometimes it can make a difference.
Anyway, I still suggest reinstalling Java in the db.
Message was edited by: