Limit of number of characters in stored procedure parameter

Dear all,

Is it a technical limitation that we can only pass a parameter which is < 1000 characters into a stored procedure?

For example, assuming i am doing a *run_stored_procedure = test_sp(%my_entity%), must %my_entity% have less than 1000 characters?

Cheers,

Lip Chean