can i relapse varchar(max) stored procedure?

vb.net web component sql server 2005 backend. i've got stored way advantage varchar, we're finally removing values won't fit varchar(8000).

i've altered relapse parameter varchar(max), nonetheless i tell oledbparameter.size ability accept any volume text?

as petrify example, vb formula got relapse parameter stored way used feeling like:

objoutparam1 = objcommand.parameters.add("@rstr", oledbtype.varchar)
objoutparam1.size = 8000
objoutparam1.direction = parameterdirection.output

what i .size work (max)?

update:

to answer questions:

for intents purposes, calm needs out chunk. (changing take some-more fundamental work i wish - am certified for, really.)

if i don't set size, i an blunder reading "string[6]: distance ability an unfair distance 0."