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

[akkerend]

Check table DUAL as mvander2 suggest. In 8i SQL*Plus returns one record if you try
SELECT SYSDATE FROM dual;
even if dual contains more rows, so try:
SELECT COUNT(1) FROM dual;