Re: What is error ORA-06512 ?

From: <uday.ketkar_at_dscoe.com>
Date: Tue, 29 Sep 1998 18:48:28 GMT
Message-ID: <6ura1s$pjs$1@nnrp1.dejanews.com>

Hello,

Just browsing Deja news, saw ur Q.

I think you need to take care for the exceptions in your PL/SQL. this error is occuring because "select" statement is expecting an exception & which is not found. Also the error will give you aprox. line number where you need to take care for expection.

Also it would be better practice if you could take care for expections for other "select" also.

Hope this helps.

Thanks,
-Uday

In article <361156ce.14324346_at_news.erols.com>, CG_at_His.PC (CG_at_His.PC) wrote:
> On 28 Sep 1998 21:40:47 GMT, long.pham_at_ips-sendero.com (Long Pham)
> wrote:
>
> >Hi all,
> >
> >I can't seem to find any documentation on this error anywhere on the Oracle
CD.
> >I get this in VB using ADO thru MS ODBC driver for Oracle version
2.573.2927,
> >trying to retrieve a recordset from an Oracle stored procedure. Does anyone
> >know what this error means ??? Thanks in advance ...
> >
> >Long Pham
>
> try logging on to the server as the Oracle user, and issue this
> command:
>
> oerr ora 6512
>
> it should give you a description, cause, and action.
> ++++++++++++++++++++++++++++++++++++++++++++++
> mp3 files posted for evaluation purposes only.
> If you like it, support the artist and buy it!
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 29 1998 - 13:48:28 CDT