Re: ora-07445 error on Oracle 10g

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)