Just figured out the answer.

I did not separate each variable using a comma in the Select stmnt.

SET @sql = 'INSERT INTO TestBlob (tbname, tbRTNo, tbPOSONo, tbBin) SELECT '''+@myparam1+''' AS tbname,...