Forum OpenACS Q&A: Oracle 9i Migration Toolkit
I was investigating this issue before I found this toolkit and I discovered another workaround. Rather than renaming the delete procedure, renaming the parameter works as well. For example:
By doing this, you don't need to change pages which call person.delete() because only the formal parameter has changed.-- original procedure delete ( person_id in persons.person_id%TYPE ) is begin delete from persons where person_id = person.delete.person_id; party.delete(person_id); end delete; -- new procedure delete ( v_person_id in persons.person_id%TYPE ) is begin delete from persons where person_id = v_person_id; party.delete(v_person_id); end delete;
I haven't completely implemented this solution yet, nor have I tried it for rename. I also have a TAR open with Oracle to see if there is a "lax package syntax" flag available or some other easier solution.
Sorry for responding to such an old thread, but it's a current topic for me.