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:
This problem can occur on any platform.


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

create table bugs (bug_id integer);
insert into bugs values (1);
create or replace function bug_func (param in integer)
return varchar2
return 'Plun';

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


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