ora-06502 sometimes

Quote:

---

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.

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.

proof:

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

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