single row query rteturn more than one row

[Xiaoxia Dong]

i got following message when i run sql statement as sql

sql=select up_time from uptime where
             startdate = (select GREATEST(startdate)
                                  from uptime where
                                  hostname = 'twister')
DBD::Oracle::st execute failed: ORA-01427: single-row subquery returns
more than one row (DBD ERROR: OCIStmtExecute) at upget.pl line 35.

ORA-01427: single-row subquery returns more than one row (DBD ERROR:
OCIStmtExecute)

i only have one row under hostname 'twister' in the table and it runs
fine under oracle sql>.


dong