Windows error 0x80131938, -2146232008

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

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

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

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

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

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

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

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

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

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

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

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

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

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

.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

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

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

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

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