To create an LOB parameter:, use
create procedure proc_name [@parameter_name LOB_datatype as {SQL_statement}
This example creates the new_proc procedure which uses the text LOB datatype:
create procedure new_proc @v1 text as select char_length(@v1)