The size is indeed the only difference. If you require more than 4000 bytes of character data to or from your PL/SQL Block, you need to use the otPLSQLString data type.