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

From: Tanel Poder <tanel_at_@peldik.com>
Date: Wed, 23 Jul 2003 21:36:41 +0300
Message-ID: <3f1ed5b9$1_1@news.estpak.ee>

Hi!

Which version and platform?

That's just a wild guess, but what happens when you replace this DBMS_LOB.Substr function temporarily with constant such is "xxx" or whatever..

Tanel.

"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
Received on Wed Jul 23 2003 - 13:36:41 CDT