Refactoring .... Rename Item for Type does not work.

[Sachin]

TYPE ty_one IS TABLE OF cur1%ROWTYPE INDEX BY PLS_INTEGER;
tab_one ty_one;

Attempt to use Refactoring ... Rename Item and on line one ty_one and change it to ty_two. Nothing happens.

The entire code is valid and is currently compiled successfully in the database.

Using refactor on tab_one changes it correctly at all places in the code.

Thanks,

 

[Marco Kalter]

This works fine for me. Can you send me a complete code example by e-mail?

 

[Sachin]

Marco,

It is not working in a couple of my packages and works everywhere else - so something is causing it to fail.
Unfortunately, I cannot send you the package code (due to constraints at work), however, I will try to duplicate it in a simpler sample package and email it to you.

Thanks,

 

[Sachin]

Marco,
Here is a simple code where it does not seem to work.

CREATE OR REPLACE PACKAGE pkg_test IS

-- Author  : E49436
-- Created : 6/23/2009 3:04:27 PM
-- Purpose : Test.

-- Public type declarations

-- Public constant declarations

-- Public variable declarations

-- Public function and procedure declarations

END pkg_test;
/
CREATE OR REPLACE PACKAGE BODY pkg_test IS

  -- Private type declarations

  -- Private constant declarations

  -- Private variable declarations

  -- Function and procedure implementations
  PROCEDURE p_1 IS
    TYPE ty_test_one IS TABLE OF sample_table%ROWTYPE INDEX BY PLS_INTEGER;
    tab_test_on ty_test_one;
  BEGIN
    NULL;
  END p_1;
END pkg_test;
/

 

[Marco Kalter]

That does indeed not seem to work. We'll fix it.