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)
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]