Creating a LOB Parameter

Use the create procedure command to create an LOB parameter.

create procedure proc_name [@parameter_name LOB_datatype
as {SQL_statement}

Example 1

This example creates the new_proc procedure, which uses the text LOB datatype:
create procedure new_proc @v1 text
as
select char_length(@v1)