oracle error 'Missing Keyword' ora 00905

Here's the code:

        v_rangeFrom :=' SELECT unique (add_months(last_day( bus_cal_d)+1,-1)) '||

                      '   FROM cscadmin.business_calendar '||
                      '  WHERE to_CHAR(bus_cal_d,'|| chr(39)||

                                                                      
                     '  FROM TIME_DIMN ' ||
                                                                      
                     ' WHERE tme_dimn_i = ' || chr(39) || 'TDTD' ||

In dynamic pl/sql, I'm trying to extract a date and set to a variable, v_rangeFrom is showing the entire select statement if I were to print out the variable. I'm trying to extract a specific date from a table to load into the variable, but I'm getting an oracle ora 00905 error keyword missing.

help please??? Received on Thu May 16 2002 - 17:48:35 CEST