Forum OpenACS Q&A: Re: OpenACS 5.1 in Oracle 9i

diff -r acs-content-repository/sql/oracle/content-item.sql /usr/local/CVS/openacs-4-all/openacs-4/packages/acs-content-repository//sql/oracle/content-item.sql
611,614d610
<  v_item_id cr_items.item_id%TYPE;
<  v_name    cr_items.name%TYPE;
<
<
621c617
<      cr_items.name = v_name
---
<blockquote>      cr_items.name = content_item.rename.name
</blockquote>
628c624
<                    cr_items.item_id = v_item_id);
---
<blockquote>                    cr_items.item_id = content_item.rename.item_id);
</blockquote>
639,640c635,636
<      set cr_items.name = v_name
<              where cr_items.item_id = v_item_id;
---
<blockquote>      set cr_items.name = content_item.rename.name
              where cr_items.item_id = content_item.rename.item_id;
</blockquote>