Janine,
You might have to put it on one line like this:
select select count(*) from cr_revisions where item_id = item_id) as item_count, 'Revision ' || content_revision.get_number(revision_name.revision_id) || ' of ' || revision_name.item_count || ' for item: ' || content_item.get_title(item_id)
into v_text
I had a similar problem when I was working on survey, and I checked, all the select foo into bar has the select foo on one line.
