Schema Browser | Tables tab | right-click a table | "Create DML Procedures" | Other Options tab | “In Parameters:” text box.
How to change it from “in_%ColumnName%” to “in_ColumnName%_%ColumnDataType%” or if possible "in_ColumnName%_%FirstLetterOFColumnDataType%”.
For example (end results like this):
from:
in_Col01
to:
in_Col01_Varchar2
or better yet and if possible:
in_Col01_V
("V" is for the first letter of the column datatype)
Toad for Oracle does not have the aforementioned functionality. Please submit this as an Enhancement Request (ER) (or vote for it if it already exists) via our “Toad Idea Pond” site for a possibility to add this feature in a future release of Toad for Oracle.
We value our customer’s needs / wants and every Toad version is created / designed with many user inputs in mind. The feature mentioned above is currently not available in the current version of Toad for Oracle. To log an enhancement request for this feature, please visit the "Toad Idea Pond". This site is solely dedicated to tracking customer enhancement requests and allowing the user community to vote on the most useful feature. The development team personally monitors this website and provides customer feedback on their enhancement requests.