ORA-01427: single-row subquery returns more than one row

I am trying to create a temp table on the fly using this statement CREATE TABLE tempDOC_20619 tablespace infoedtemp AS SELECT s.PI_FULL_NM,s.INST_NO,s.PI_UNIT_NM,s.PRI_NAMEH,DBMS_LOB.Substr(s.PROJ_TITLE,4000,1) PROJ_TITLE,s.SEC_NAMEH,s.REVIEWTYPE from HS_SUPER s where s.prop_no in (select min(prop_no) from humansub where inst_code='U_NEWHAMP') It throws an error : ORA-01427: single-row subquery returns more than one row

The weird thing is when i just run the select statement from the above create table statement it works fine with no error. But when i run it with create table it throws an error. Any help is appreciated.

Thanks Received on Wed Jul 23 2003 - 10:06:48 CDT