Re: ora-07445 error on Oracle 10g

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1083604278.740222_at_yasure...
> Gordon wrote:
>
> > Hi,
> >
> > I'm running into a lot of ORA-07445 (Address not mapped to object)
errors on
> > Oracle 10g on Red Hat Adv Server 3.
> > This same problem occurs every time as Oracle tries to execute a
procedure
> > from the WKSYS schema:
> > ORA-07445: exception encountered: core dump [eoaccess_IU()+165]
> > [SIGSEGV] [Address not mapped to object] [0x5E4E08] [] []
> > Current SQL statement for this session:
> > DECLARE
> > job BINARY_INTEGER := :job;
> > next_date DATE := :mydate;
> > broken BOOLEAN := FALSE;
> > BEGIN
> > wksys.wk_job.invoke(1,2); :
> > mydate := next_date;
> > IF broken THEN :
> > b := 1;
> > ELSE
> > :b := 0;
> > END IF;
> > END;
> >
> >
> > Appreciate your help!
>
> Take a look at this:
>
> > IF broken THEN :
> > b := 1;
> > ELSE
> > :b := 0;
> > END IF;
>
> Why does one have a colon and other not?
> And where has this variable been declared?
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>

The colon is after the key work "THEN", I didn't do a very good job when reformatting this block from trace file
This code block is not written by anybody, it is an Oracle internal PL/SQL block that performs its workflow task. Received on Mon May 03 2004 - 12:21:11 CDT