Re: ORA-20002

From: Klaus Zeuch <KZeuchnospam_at_hotmail.com>
Date: Wed, 11 Apr 2001 13:21:59 +0200
Message-ID: <9b1ied$2h8$1@papyrus.erlm.siemens.de>

Jan Schäfer <schaefer_at_kksl.uni-leipzig.de> schrieb in im Newsbeitrag: 9b1af8$p6r$1_at_news.uni-leipzig.de...
> Hi,
>
> I got the error message ORA-20002 but can't find this error number in the
> docs.
> Does anyone knows this error number?
>
> Thanks,
>
> Jan
>
>

From 8.1.7 manual; several scenarios for ORA-20002 are possible:

ANALYZE_OBJECT Procedure....
ORA-20002: METHOD must be one of COMPUTE, ESTIMATE or DELETE.

Package dbms_describe
ORA-20002: ORU-10033: object 'X' is remote, cannot describe; expanded name 'Y'.

Net8 can also generate error 20002:
Net8 OPEN API Errors
This section lists the error numbers that can be returned if one of the above function calls fails. Note that in some cases, connection-related errors may come back from a send or receive call, if the connection has not yet been established at that time.

20002 - SDFAIL_TNSAPIE - The underlying "send" command failed in tnssend().

Hope one of the environments above applies Received on Wed Apr 11 2001 - 06:21:59 CDT