Just read an AskTom question that discusses how to use bind variables in dynamic SQL. Just thought I'd add a link to this thread.

http://asktom.oracle.com/pls/ask/f?p...0_P8_DISPLAYID,F4950_P8_CRITERIA:2531562164953,

Heath