RE: Urgent: Oracle ORA-02112 Error

Your select statement is returning more than 1 row. You will either have to revise where clause
to limit to 1 row being returned or you will have to restructure using a fetch into...

Rick

> -----Original Message-----
> From: Kamesh.J.Mantri_at_citicorp.com [SMTP:Kamesh.J.Mantri_at_citicorp.com]
> Sent: Monday, October 09, 2000 1:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Urgent: Oracle ORA-02112 Error
>
> Hi Listers,
> I have ORA -02112 Error coming when I am using Pro* C code to select a
> row
> into
> a structure. This is a transient error where the error rotates around one
> select.
> If the select is successful the values that Oracle returning is garbage.
> Is
> this
> possible ?
>
> Actually the table contains correct data with one record.
>
> Cud you pl. help me in this regard.
>
> Thanks
> Kamesh.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Kamesh.J.Mantri_at_citicorp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Oct 09 2000 - 13:13:43 CDT