On Thu, Mar 15, 2001 at 02:43:45PM -0500, Xiaoxia Dong wrote:
> 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>.
GREATEST() is the wrong function to use here. I believe you want MAX()
instead.
Ronald