Column length question.

   Dear Experts,
As I know it is possible to use in stored procedures a column type definition for a variable declaration like the following:

myVariable tableName.columnName%TYPE;

Is it possible (and how) to use a column size definition? Something like:

IF (length(myVariable) > tableName.columnName%SIZE) THEN  .... do something ....
END IF;    Regards,
     Serguei. Received on Tue Nov 21 2006 - 09:14:15 CST