Set define off.....how?

I had a cursor, in which some of the variables (varchar2) contained the ampersand character(&).

They worked fine, but once I changed over to a dynamic sql statement, it began to ask for a definition for the &. I am creating a directory and some of the titles use &'s, and I can't seem to get around it.

I have Set Define Off at the top of my procedure....what am I missing?

Using 8.1.0.6.

--
Joseph Ranseth - Webmaster
World Cup Fishing
http://www.worldcupfishing.com