amar on web

%type use in forms 6i

What is the impact of increasing the size of a column in a table when the same is being referred in %type definition in forms 6i code. A trigger in forms 6i refers a column to define its variable type. After the .fmx has been successfully generated, the column size is increased. Will this result in any error? (or, Oracle takes care of the change)

   declare 
        l_nam       emp.ename%type; 
   begin 
   ... 
   end;

The generated fmx converts the %type reference to the actual datatype and size of the column, at that point in time. Hence, the fmx will be created with old size of the column. During runtime, if the variable is assigned a value more than the old size, it will throw ORA-06502 error. Solution is to regenerate the fmx file to reflect the change made in the structure.

Best viewed in medium text size. Please refresh this page (F5) to view the latest information.
This page was created on 01-jan-2002 and last updated on 01-jan-2002.
please forward all queries to [email protected]