It worked in SQL*Plus in a straight query, but when they put it in a pl/sql block .. they got the error.

The developer(s) cluged together a solution using pl/sql tables and vars.

I think we'll be on 9i before we figure that one out.

Thanks folks for your input.