Creating a LOB parameter

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)