Forum OpenACS Q&A: Re: Tricky query port (pg -> oracle)

Posted by Janine Ohmer on
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.