Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> java stored procedure ora-29540
I am receiving ORA-29540 from a Java trigger when inserting rows into a
table.
I have successfully created and tested a class DBTrigger which is refered to in the call spec of a stored procedure, which is in turn called by a trigger:
CREATE OR REPLACE TRIGGER my_trigger
AFTER INSERT ON my_table
FOR EACH ROW
CALL my_stored_procedure(:new.column_name)
CREATE OR REPLACE PROCEDURE my_stored_procedure (colomn_name NUMBER)
AS LANGUAGE JAVA
NAME 'DBTrigger.myMethod(int)';
The Java class DBTrigger.class contains a single method myMethod.
I have created a simple class which inserts rows into the table to perform some simple load testing. The process succeeds for about the first 20 rows. After the 20th or so insert, I begin receiving the following error:
ORA-29540: class DBTrigger does not exist ORA-04088: error during execution of trigger 'MY_DB.MY_TRIGGER'
Obviously the class exists, as it has been called 20 times up to now. USER_OBJECTS claims that the class is still valid. If I drop and recreate the stored procedure and trigger, the process will work again for another 20 or so inserts.
Any insights? I cannot even find a reference to this error # on Oracle's site.
Oracle 8i NT SP5
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Nov 04 1999 - 15:55:32 CST
![]() |
![]() |