ora-06502 sometimes

[gandolf989]

Originally posted by stecal
CREATE OR REPLACE FUNCTION RAY.basename

Is this a cut and paste job, or is there a difference between RAY.basename and DKRAY.basename? Your original error message references DKRAY.basename, but the function you posted is RAY.basename.

So he keeps trying to fix the one that works and then runs it against the function that doesn't work. Good catch.

[DBAtrix]

i was a cut & paste error. i edited out the name and some comments from the DDL generated from the function. there is only one function in existence.

[DBAtrix]

proof:

SQL> r
1 select count(distinct owner) from dba_source
2* where name ='BASENAME'

COUNT(DISTINCTOWNER)
--------------------
1