Did you ever get this to work?
I am evaluating CRD and could not get the dynamic schedule working (Oracle 8.1.7). I have logged a support call and also tried bursting schedule. So far my diagnosis is it has something to do with parsing sql via odbc to supply the data to the parameter or destination directory. I could schedule task to update or insert rows into the oracle database. I also noticed that the tables list come up without schema prefix and I always have to use 'advanced option' to key in the schema prefix else it won't be parsing correctly.
Tx