URGENT !!! EXACT FETCH RETURNS MORE THAN ONE ROW WHEN SELECTING SYSDATE

[balajiyes]

HI,

IF WE ARE SELECTING SYSDATE OR SEQ.NEXTVAL INSIDE A PLSQL BLOCK,WE ARE GETTING THE ERROR EXACT FETCH RETURNS MORE THAN REQUESTED NO OF ROWS..IF WE EXECTUE IN SQL PROMPT IT'S WORKING FINE..IT'S URGENT...