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

[balajiyes]

HI,

I CHECKED IT ..THERE IS ONLY ONE ROW...THIS PROBLEM ARISES ONLY IN A PLSQL BLOCK..IF WE ISSUE IT IN SQL PROMPT..THEN NO PROBLEM..


ALSO IF WE SELECT

SELECT SEQ_ID.NEXTVAL FROM DUAL;

INSIDE A PLSQL BLOCK WE ARE GETTING THE SAME ERROR..EXACT FETCH RETURNS MORE THAN REQUESTED NO OF ROWS...

SAME ERROR COMES FOR


SELECT SEQ_ID.NEXTVAL FROM DUAL;


THANX