Windows error 0x80131938, -2146232008

Detailed Error Information

COR_E_OracleException[1]

Comment System.Data.OracleClient.OracleException

HRESULT analysis[2]

FlagsSeverityFailure
Reserved (R)false
OriginMicrosoft
NTSTATUSfalse
Reserved (X)false
FacilityCode19 (0x013)
NameFACILITY_URT[2][3]
DescriptionThe source of the error code is .NET CLR.[2][3]
Error Code6456 (0x1938)

Questions

3votes
2answers

How can I run several different `insert` statements in a single call with ADO.NET and Oracle?

The following works with MS SQL Server, but our Oracle system throws an error: ORA-00911: invalid character string strQuery = @" insert into DEVICE ( DEVICE_ID, DEVICE_NAME, TIMESTAMP) values (:DEVICE_ID,:DEVICE_NAME, sysdate); insert into INV ( INV_ID, DEVICE_ID, COMMENT, TIMESTAMP) values (:INV_ID,:DEVICE_ID,:COMMENT, sysdate); "; OracleConnection conn = getConn(); OracleCommand cmd = [...] read more
.net
sql
oracle
batch-file
2votes
1answer

Oracle9i connection error (ora-12154) in .NET application only on some machines

I made a .NET(4.6.1) application that connects to an Oracle9i Database. This application works fine on the machine I wrote the application on but not on the machine where the application needs to be installed on. I'm using System.Data.OracleClient. I have no idea what could be wrong. I checked the [...] read more
.net
windows-7
oracle9i
system.data.oracleclient
ora-12154
2votes
1answer

ORA-12582: TNS:invalid operation, using CLOB datatype in database table

We are having 2 servers. I am working with .Net and oracle. Both the servers are having same oracle version 11g (11.2.0.1.0). One scenario (getting values from Database table, in that one column datatype is CLOB and binding to div) is working fine in one server. But the same scenario [...] read more
.net
oracle11g
2votes
2answers

How to debug visual studio connection to oracle database (ORA-1254 & ORA-12638)?

BACKGROUND I am working a new job and trying to set up my local environment. At the moment, I cannot debug our web solutions on visual studio 2008 because I believe I did not configure oracle 11g correctly when I installed it (getting an ORA-1254-TNS: could not resolve identifier specified" [...] read more
debugging
windows-7
oracle11g
installation
reverse-engineering
2votes
1answer

UPDATE gridview row error

<asp:SqlDataSource ID="charges_gv_datasource" runat="server" ConnectionString="edited" ProviderName="System.Data.OracleClient" SelectCommand="WITH relevant_ids AS (SELECT ir.result_id AS relevant_result_id FROM inspection_result_tbl ir) SELECT ir.charge_id, LISTAGG(ir.result_id, ', ') WITHIN GROUP (ORDER BY ir.charge_id) AS result_ids, ch.charge_progress, ch.claim_verification, ch.hours_allowed, ch.sap_notification, ch.total_checked, ch.charge FROM inspection_result_tbl ir LEFT JOIN relevant_ids ON ir.result_id=relevant_ids.relevant_result_id LEFT JOIN charges_tbl ch ON ir.charge_id=ch.charge_id WHERE ir.charge_id IS [...] read more
asp.net
sql
gridview
updatecommand
1vote
2answers

add record nlog date get error invalid month

I use nlog dll to write to database - oracle with entity frameWork in the line : logger.Log(logLevel, "try"); I get in the logs of NLog the following error: > Warn DatabaseTarget: Parameter: 'TIME_STAMP' - Failed to assign > DbType=OracleDbType.Date Error DatabaseTarget(Name=WS_TRACE): Error when > writing to database. Exception: System.Data.OracleClient.OracleException [...] read more
c#
oracle
date
nlog
1vote
0answers

log4Net logging improper message

I've deployed log4Net on 2 different servers. on 1st its showing proper message like: [ERROR] [2018-01-25 19:17:00,856] [MANSOUR3185] [GicCipDataObjects.Oracle] [GetAllRequest] - DB Error System.Data.OracleClient.OracleException (0x80131938): ORA-01722: invalid number but on 2nd server it is not logging proper message: [ERROR] [2018-01-25 19:17:00,856] [MANSOUR3185] [GicCipDataObjects.Oracle] [GetAllRequest] - DB Error System.Data.OracleClient.OracleException (0x80131938): ORA-01722: [...] read more
oracle
log4net
1vote
2answers

Error executing Oracle Anonymous Block in ASP.NET MVC

I have the following anonymous block which runs just fine in Oracle SQL Developer and performs the expected insert but when I run it from my ASP.NET Code it bombs out (exception details below). DECLARE L_PKID NUMBER; P_NOTE_TXT ICE.NOTE_TEXT.NOTE_TEXT%TYPE; P_USERID ICE.NOTE_TEXT.CREATED_BY%TYPE; L_USER_NAME ICE.NOTE.CREATED_BY_NAME%TYPE; BEGIN P_NOTE_TXT := 'This is a sample [...] read more
c#
asp.net-mvc
oracle
1vote
1answer

NHibernate Oracle XMLType issue

We have one function in oracle 10g database which returns a XMLTYPE value. we are trying to get the returned value from function using ParameterDirection.ReturnValue in command object. but we are getting error as System.Data.OracleClient.OracleException (0x80131938): ORA-06550: line 1, column 27: PLS-00382: expression is of wrong type ORA-06550: line 1, [...] read more
c#
nhibernate
oracle10g
1vote
1answer

Casts when using NHibernate and Oracle

The problem of typecasting when comparing NHibernate. The error occurs when using Telerik Dynamic Custom Binding using NHibernate and Oracle database. Here is the class implements the Telerik Custom Binding which works fine with the Entity Framework and MS SQL Server 2008 when used with NHibernate and Oracle database errors [...] read more
asp.net-mvc
linq
oracle
nhibernate
telerik
0votes
0answers

Why Oracle SP with parameter Not Working with SSRS Report

I am trying to build SSRS report which using Oracle SP as backend to get data from Oracle DB. SP have only one input parameter & out put parameter ref cursor. On my client machine this is working fine but once I deployed on SSRS server it giving me error. [...] read more
oracle
reporting-services
odac
0votes
1answer

ORA-00955 error while implementing Hangfire.FluentNHibernateStorage

Hi my oracle version is: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production I am using Hangfire.FluentNHibernateStorage v1.2.1020 version. In owin startup here what I am doing in Configuration method: var options = new FluentNHibernateStorageOptions { TransactionIsolationLevel = IsolationLevel.Serializable, QueuePollInterval = TimeSpan.FromSeconds(15), JobExpirationCheckInterval = TimeSpan.FromHours(1), CountersAggregateInterval = TimeSpan.FromMinutes(5), [...] read more
c#
oracle
fluent-nhibernate
hangfire
0votes
0answers

Unable to execute Oracle queries | OracleException (0x80131938): ORA-00947

Your help is appreciated to solve the following. Am trying to execute two Oracle queries one after another in C# code. However, I get the following error: 'System.Data.OracleClient.OracleException (0x80131938): ORA-00947: not enough values in updateQuery. I checked the columns and values in the query and count is correct. Below is [...] read more
c#
oracle
0votes
1answer

ORA-O1036: Illegal variable name/number

There are alot of posts related to this question but no one work for my case. I am using oracle database with C# on visual studio void addUser() { OracleCommand cmd = new OracleCommand(); string query ="INSERT INTO users (user_id, f_name, hash, acc_type, cell_no, country, state, city, zip, address, email, [...] read more
c#
oracle
desktop
ora-01036
0votes
1answer

NHibernate: Increment function not getting next sequence value

I get the following error when I try to save an Entity with NHibernate: System.Data.OracleClient.OracleException (0x80131938): ORA-00001: unique constraint (FEMADEV.TRN_INFLOW_DETAILS_HIS_PK) violated My Controller Code: TrnInflowDetailsHis trnInflowDetailsHis = Mapper.Map<TrnInflowDetailsHis>(trnInflowDetailsAud); trnInflowDetailsHis.InflowSeq = trnInflowDetailsAud.Id; trnInflowDetailsHisService.Add(trnInflowDetailsHis); Mapping Code: public class TrnInflowDetailsHisMap : ClassMap<TrnInflowDetailsHis> { public TrnInflowDetailsHisMap() { Table("TRN_INFLOW_DETAILS_HIS"); LazyLoad(); Id(x => x.Id).Column("INFLOW_ID").GeneratedBy.Increment(); Map(x => [...] read more
c#
asp.net-mvc
oracle
nhibernate
increment
0votes
0answers

.Net oracle connection fail

I have created a web application in .net and the connected database is oracle. it's working properly in the localhost but whin i publish it in to an IIS server, sometimes it's working fine but sometimes it's not. it says that ORA-12545: Connect failed because target host or object does [...] read more
asp.net
oracle
0votes
0answers

ORA-06413: Connection not open, works fine in Visual Studio C# but gives error in Installer

I have developed an application that uses Oracle Database to insert/query. Application works fine when I run using Visual Studio, but when I create its MSI Setup using Visual Studio Installer or Inno Setup Creation, it doesn't connect to Database and gives error on OracleConnection.Open(). Here is its full exception [...] read more
c#
oracle
installation
database-connection
0votes
1answer

Use ASP.Net insert command to apply on an ORACLE database table

Good day! I'm trying to insert just an entity to a single field in an ORACLE database table but I'm having this error in my Stack Trace: **Stack Trace**: > [OracleException (0x80131938): ORA-12154: TNS:could not resolve the connect > identifier specified ] > System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, > Int32 rc) +338968 > [...] read more
asp.net
oracle
0votes
1answer

Execute 32bit C# console application which connects to Oracle 9.2 on Windows 2003 R2 Server

I have problems launching a small C# console application to run on Windows 2003 R2 Server. The demo is used to check why the connection to Oracle 9.2 that is situated on the Windows 2003 R2 Server can't be established running the same code from WCF hosted on IIS. static [...] read more
c#
sql
oracle
wcf
oracle11g
0votes
1answer

Fluent NHibernate - how to specify sequence name for Id with GeneratedBy.Native()

I use Fluent NHibernate and I need to use GeneratedBy.Native() for Id generation to support Oracle,DB2 and MSSQL databases. If I try to run it like this on Oracle and insert new record to the table I get: Could not execute query: select hibernate_sequence.nextval from dual System.Data.OracleClient.OracleException (0x80131938): ORA-02289: sequence [...] read more
c#
fluent-nhibernate
nhibernate-mapping
fluent-nhibernate-mapping

Comments

Leave a comment

(plain text only)

Sources

  1. https://github.com/dotnet/coreclr/blob/v1.1.0/src/inc/corerror.xml
  2. https://msdn.microsoft.com/en-us/library/cc231198.aspx
  3. winerror.h from Windows SDK 10.0.14393.0

User contributions licensed under CC BY-SA 3.0