and one more correction, cursor_name should be cursor_bob.
For completeness, here is a SQL Server implementation using Contains Full Text Indexing, this works. I would much rather do this on Teradata and NOT pull all the TEXT down, even at 50-100k rows a second it takes a very long time to ETL, do a rollup, then ETL back to Teradata. Not a fan of having to ETL to SQL server to perform a rollup operation because TeraData can't handle it. (kidding, but not really) ;)
CREATE procedure [dbo].[Term_Tagging] as