Actually i havnt yet written the code as i am not getting the logic...

what i want to do is ... my procedure will be having an input from front end of date as 2007 now this date have to be queried on data in a cursor and give me output form 1-1-2007 to 12-30-2007
it should get me all the data of that year,... how is this possible,... i have no idea,... can anyone help me out with this plzzzz

NBSR