Hi everyone,
can somebody tell me something about the following error:
Error 2427 (bdb_errno 2427) on SELECT ?
The fact is that the SELECT above works on a company and give that error in another company.

Other information: BaaN iV, Oracle, Windows NT

Thanks.

Is there any other information in any of the other log files(log.bshell, log.oracle, etc.)?

Mark

So something is screwy in your SQL statement.

You'll have to publish it for more details though.

Hi Francesco,
you are rigth. I've just modified my subquery: I didn't believe it was possible to retrieve more than 1 row (according to the data I had). I'm not authorized to read any log so I couldn't give any information, except for the error code.
2427 - 1000 = 1427, but this error code means nothing for me. Where can I find an Oracle error list with error explanation?

Thanks again for yuor help,
Ivana

Where can I find an Oracle error list with error explanation?

There is a command in Oracle, but I forgot what it is. I usually just google it.

ORA-01427single-row query returns more than one row

Cause:The outer query must use one of the keywords ANY, ALL, IN, or NOT IN to specify values to compare, because the subquery returned more than one row.

Action:Use ANY, ALL, IN, or NOT IN to specify which values to compare, or reword the query so only one row is retrieved.

There is a command in Oracle, but I forgot what it is. I usually just google it.

[DEV:bsp]/app/common/home/bsp>oerr ora 1427
01427, 00000, "single-row subquery returns more than one row"
// *Cause:
// *Action:
[DEV:bsp]/app/common/home/bsp>
You can also get more information from -

http://technet.oracle.com

or

http://metalink.oracle.com