Nope, now I've got
select 'Revision ' || content_revision.get_number(r.revision_id) || ' of ' || (select count(*) from cr_revisions where item_id = r.item_id) || ' for item: ' || content_item.get_title(item_id) into v_text
from cr_revisions r
where r.revision_id = test_func.revision_id;
but I'm getting the same error. I tried putting it *all* on one line, too, but that didn't help either.
I can split it up, but it will have to be two selects then and I'd rather not have to do that. I'm beginning to think I will have to, though.
