"GR" <grajput_at_msn.com> wrote in message
news:8c94f316.0307230706.3888255a_at_posting.google.com...
> 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
Try adding "ROWNUM=1" to your sub select.
Received on Wed Jul 23 2003 - 10:36:05 CDT
