It seems like it would probably be this part - however I'm honestly not sure.
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') I would first question why you would want to create a temporary table on the fly. Doesn't that defy the point of temporary emails in the first place? HTH (?) Mark > Rajput, Goutam <[EMAIL PROTECTED]> wrote: > > I am trying to create a temp table on the fly using this statement > CREATE TABLE tempDOC_20619 tablespace infoedtemp AS SELECT > ,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. ----------------------------------- [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [www.safefrombees.com] ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
