Ora-0600 [Evapls1] Can Occur While Selecting From Table Using Functions (Doc ID 342663.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1
This problem can occur on any platform.
10.2.0.1.0

Symptoms

ORA-00600 [EVAPLS1] can occur, while selecting from table using functions.

Example:
create table bugs (bug_id integer);
insert into bugs values (1);
create or replace function bug_func (param in integer)
return varchar2
is
begin
return 'Plun';
end;
/

Following select will return ORA-00600 [evapls] error

select rownum, bug_id from(select bug_id from bugs where
bug_func(bug_id) like '%Plun%' order by 1) ;

Call Stack:
evapls evaopn2 evalik expepr expeal qervwRowProcedure qersoFetch qervwFetch qercoFetch

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms