Looks like one of those "Too close to the problem" types of situations.



-----Original Message-----
From: Jim Thomas
[mailto:oracledba-ezmlmshield-x82093722.[Email address protected]
Sent: Monday, April 28, 2008 3:17 PM
To: LazyDBA Discussion
Subject: RE: REASONS FOR ERROR ORA-01427: single-row subquery returns
more than one row error

Jack- and everyone else- Can we say ' stupid idiot ' ?

Cause that's how I am feeling right now

Here is the query from the source table

This is funny in a sad way!!!

I did a single query and noticed that my source table had
5 unique records- this table has no constraints,

I then did a select po_num and po_line on the po
and look what I found- I am thinking that when the data was converted
from
another table(production) somehow the field length became len=1 or all
double digit numbers got cropped, those extra (1) ones are really
10,11,12 etc...

I will need to rework my data- then I will cry wolf if necessary.
SQL> select po_number,po_line_number
2 from temp_pop_lines
3 where po_number='0100196'
4 ;
0100196 1
0100196 2
0100196 3
0100196 4
0100196 5
0100196 6
0100196 7
0100196 8
0100196 9
0100196 1
0100196 1
0100196 1
0100196 1

My bad- I just could not believe I had any bad data- Quelle drolle
Thanks to everyone who has given there time - I will return the favor
when I can.
regards
Jim T


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page