Re: ORA-00602 on VMS

In article <6DEC199315492102_at_author.gsfc.nasa.gov> you wrote:
: Hello group,
 

: I'm getting an ORA-00602 when doing an insert into a field with
: a trigger on it. I'm reporting it to Oracle, but I thought I'd
: get good info from you guys.
 

: Platform is VMS v5-5.2
: ORACLE7 Server Release 7.0.12.0.0 - Production
: With the procedural, distributed, and Parallel Server options
: PL/SQL Release 2.0.14.0.0 - Production

[... some particulars omitted ...]

I have gotten a similar error on 7.0.12 while using VMS. In my case, there was a SELECT statement in the trigger body which was causing the trigger to fail. I moved the offending code into a compiled procedure which I called from the trigger body, and the problem went away. Your trigger doesn't resemble mine closely (although it does change the contents of the row, and it does cause ORA-00602 with an access violation to boot), but the same process may well fix it.

Good luck,
Robert Sechrest, LMSC

Opinions expressed are my own and not those of my employer. Received on Tue Dec 07 1993 - 02:12:14 CET