Re: ORA-06512
From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Sat, 7 Feb 2009 00:50:48 -0800 (PST)
Message-ID: <9f5449ca-f4c8-4faf-b2c0-7dba3f09b161_at_f20g2000yqg.googlegroups.com>
On Feb 6, 2:55 am, stas1..._at_msn.com wrote:
> Hi,
>
> I have a .NET application which gets back a CLOB from the oracle
> database. I'm using OracleParameter("name", OracleType.Clob) for the
> parameter spec. We recently created a new Oracle AL32UTF8 unicode
> database, and I'm trying to run the app against the database, however
> I'm getting the ORA-06512 exception. The application works fine
> against a non-unicode database. The OUT variables in the stored
> procedure are defined as CLOB, and actaully when I call the stored
> procedure out of PL/SQL Developer the CLOB come back fine. Is there
> anything that I need to do in the .NET app to get to work with
> unicode?
Date: Sat, 7 Feb 2009 00:50:48 -0800 (PST)
Message-ID: <9f5449ca-f4c8-4faf-b2c0-7dba3f09b161_at_f20g2000yqg.googlegroups.com>
On Feb 6, 2:55 am, stas1..._at_msn.com wrote:
> Hi,
>
> I have a .NET application which gets back a CLOB from the oracle
> database. I'm using OracleParameter("name", OracleType.Clob) for the
> parameter spec. We recently created a new Oracle AL32UTF8 unicode
> database, and I'm trying to run the app against the database, however
> I'm getting the ORA-06512 exception. The application works fine
> against a non-unicode database. The OUT variables in the stored
> procedure are defined as CLOB, and actaully when I call the stored
> procedure out of PL/SQL Developer the CLOB come back fine. Is there
> anything that I need to do in the .NET app to get to work with
> unicode?
ORA-6512 is error stack backtrace message (that is, it's being output for each error stack entry as the error stack of an unhandled exception that was raised in a stored procedure unwinds.) What's the exception itself? Can you provide full error stack and relevant PL/SQL code where it's being raised?
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Sat Feb 07 2009 - 02:50:48 CST