Type of stored procedure Type

Question

I have a question about in the parameter type of a stored procedure. Typically, a parameter definition will look like this:

in param_test VARCHAR(100)

Do you know if I can define such a parameter ?:

in param_test table.column%type

Thus, the parameter will be of the same type as the column of a particular table. Therefore, if the column type changes from varchar (100) to varchar (250), I do not need to change the parameter type in the stored procedure.

I know this is possible in Oracle, but I do not know if it is in MySQL.

Thanks so much for your time and help.

Sincerely.

Answer 1

MySQL. .

varchar, TEXT ,

Answer 2

. mysql_CommandLtp.Parameters.Add( "@prmName", MySqlDbType.Text); mysql_CommandLtp.Parameters [ "@prmName" ]. = prmName.ToString(). Trim();