Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Oracle INSERT via OleDbCommand or OracleCommand returns immediately ?

103 views
Skip to first unread message

Alex

unread,
Nov 21, 2002, 7:00:12 AM11/21/02
to
Greetings,

I have a real strange issue with an Oracle call.

Its a C# Console app (a testbed for a Windows Service) that, on a
Timer event, creates an object containing the db code and processes a
series of inserts from a SQL Server database into Oracle. Simple
stuff.

SELECTs work fine, but when I perform an INSERT or UPDATE the
Command.ExecuteNonQuery() call returns to the final Console.ReadLine()
almost immediately with NO exception, the remaining code in the object
does NOT execute AND the timer never fires again ?! The Thread created
by the OnTimer event simply appears to drop !

I have tried the OracleClient and OleDb, both exhibit the same
symptoms.

It must be something to do with the Oracle database because all the
SQL Server code works fine (as always).

Anyone ever seen this before ?

Environment
-----------
Oracle 8.1.6 Enterprise Database
Oracle 8.1.6 Client
.NET v1.0.3705 (SP2)

Gary

unread,
Nov 22, 2002, 4:03:14 AM11/22/02
to
It hears strange. Is there any code?

Gary

This posting is provided "AS IS", with no warranties, and confers no
rights. Enjoyed ASP.NET? http://www.asp.net

Alex Maddern

unread,
Nov 22, 2002, 4:18:58 AM11/22/02
to

Well, there ya go. Typical isnt it. Because I had a third party SQL
editor connected to Oracle, to view the updates, Oracle for some reason
decided that it would play nice.

Turn off the SQL editor allowed the system to work fine. I am now
monitoring the updates from ANOTHER machine.

Al

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

0 new messages