Using utldtree.sql to Determine Where Your Application Needs Change

Use the utility, rdbms/admin/utldtree.sql, to determine which parts of your application potentially need rewriting when you ALTER your LONG tables to LOBs.

utldtree.sql allows you to see all objects that are (recursively) dependent on a given object. In addition, you will only see objects for which you have permission.

Instructions on how to use utldtree.sql is documented in the file itself. Hence you can see all objects which depend on the table with the LONG column, and compare that with the cases documented in the section titled "Applications Requiring Changes When Converting From LONGs to LOBs" , to see if your application needs changing.

utldtree.sql is only needed for PL/SQL. For SQL and OCI you do not need to change your applications.