How to select a partition dynamically

 Hi - I currently run procedures against hourly data.  I am using an oracle job that runs a prcedure to determine the specific partition that is ready for processing.  I then call another procedure with the specific hour as input.  This second procedure has a select against the entire table.  I want to modify the code to only select on the partition, i.e. FROM table-name partition (tbl_yyyymmddhh).  I am not able to use a bind variable here as I get an error.  Is there a way to do what I want to do or do I need to look at re-writing