473,320 Members | 1,820 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

OracleException

When we do remote calls to a component that throws a System.Data.OracleClient.OracleException, we see a SerializationException when the original OracleException is being deserialized on the client

Any ideas

22-Apr-2004 10:05:46---System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.Serialization.SerializationExceptio n: Member message was not found
at System.Runtime.Serialization.SerializationInfo.Get Element(String name, Type& foundType
at System.Runtime.Serialization.SerializationInfo.Get Value(String name, Type type
at System.Data.OracleClient.OracleException..ctor(Ser ializationInfo si, StreamingContext sc
--- End of inner exception stack trace --

Server stack trace:
at System.Reflection.RuntimeConstructorInfo.Serializa tionInvoke(Object target, SerializationInfo info, StreamingContext context
at System.Runtime.Serialization.ObjectManager.Complet eISerializableObject(Object obj, SerializationInfo info, StreamingContext context
at System.Runtime.Serialization.ObjectManager.FixupSp ecialObject(ObjectHolder holder
at System.Runtime.Serialization.ObjectManager.DoFixup s(
at System.Runtime.Serialization.Formatters.Binary.Obj ectReader.Deserialize(HeaderHandler handler, __BinaryParser serParser, Boolean fCheck, IMethodCallMessage methodCallMessage
at System.Runtime.Serialization.Formatters.Binary.Bin aryFormatter.Deserialize(Stream serializationStream, HeaderHandler handler, Boolean fCheck, IMethodCallMessage methodCallMessage
at System.Runtime.Serialization.Formatters.Binary.Bin aryFormatter.UnsafeDeserializeMethodResponse(Strea m serializationStream, HeaderHandler handler, IMethodCallMessage methodCallMessage
at System.Runtime.Remoting.Channels.CoreChannel.Deser ializeBinaryResponseMessage(Stream inputStream, IMethodCallMessage reqMsg, Boolean bStrictBinding
at System.Runtime.Remoting.Channels.BinaryClientForma tterSink.DeserializeMessage(IMethodCallMessage mcm, ITransportHeaders headers, Stream stream
at System.Runtime.Remoting.Channels.BinaryClientForma tterSink.SyncProcessMessage(IMessage msg

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage reqMsg, IMessage retMsg
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData& msgData, Int32 type
at OracleExceptionInterfaces.BaseSimpleData_DA.GetDat a(
at OracleExceptionClient.Form1.Button1_Click(Object sender, EventArgs e) in C:\Starr\EBusiness.Net\Applications\OracleExceptio nClient\Form1.vb:line 65
Nov 22 '05 #1
9 4932
Hi Mike,

Currently I am looking for somebody who could help you on it. We will reply
here with more information as soon as possible.
If you have any more concerns on it, please feel free to post here.
Thanks for your understanding!

Best regards,

Gary Chang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

Nov 22 '05 #2
Hi Mike,

Currently I am looking for somebody who could help you on it. We will reply
here with more information as soon as possible.
If you have any more concerns on it, please feel free to post here.
Thanks for your understanding!

Best regards,

Gary Chang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

Nov 22 '05 #3
Hello,

Thanks for your post. As I understand, the problem you are facing is that
it fails to deserialize an OracleEception. Please correct me if there is
any misunderstanding. I think more information is needed before moving
forward:

1. What's the version of .NET Framework, 1.0 or 1.1?
2. What's the content of OracleException?
3. Could you please post some code snippet which will demonstrate the
problem?

I look forward to hearing from you.

Regards,

HuangTM
Microsoft Online Partner Support
MCSE/MCSD

Get Secure! -- www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Nov 22 '05 #4
Hello,

Thanks for your post. As I understand, the problem you are facing is that
it fails to deserialize an OracleEception. Please correct me if there is
any misunderstanding. I think more information is needed before moving
forward:

1. What's the version of .NET Framework, 1.0 or 1.1?
2. What's the content of OracleException?
3. Could you please post some code snippet which will demonstrate the
problem?

I look forward to hearing from you.

Regards,

HuangTM
Microsoft Online Partner Support
MCSE/MCSD

Get Secure! -- www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Nov 22 '05 #5
Tim -

Here are the answers to your question

1. We are using the 1.1 framework

2. When the debuging the "server side", the Server Exception i
? ex.tostrin
"System.Data.OracleClient.OracleException: ORA-00942: table or view does not exis

at System.Data.OracleClient.OracleConnection.CheckErr or(OciHandle errorHandle, Int32 rc
at System.Data.OracleClient.OracleCommand.Execute(Oci Handle statementHandle, CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals
at System.Data.OracleClient.OracleCommand.Execute(Oci Handle statementHandle, CommandBehavior behavior, ArrayList& refCursorParameterOrdinals
at System.Data.OracleClient.OracleCommand.ExecuteRead er(CommandBehavior behavior
at System.Data.OracleClient.OracleCommand.System.Data .IDbCommand.ExecuteReader(CommandBehavior behavior
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet
at OracleExceptionTest.SimpleData_DA.GetData() in C:\Starr\EBusiness.Net\Applications\OracleExceptio nTest\SimpleData_DA.vb:line 59

3. Here are the 2 pieces of code involvedâ€

SERVER PROCES
Tr

oDs = New DataSe
'Connecting to a valid Oracle D
oConn = New OracleClient.OracleConnection("Server=DWT.world;Ui d=leguser;Pwd=north01"
oConn.Open(
'The following lines cause an oracle exceptio
Dim oCommand As New OracleCommand("Select * from DWT.bob", oConn
oDA = New OracleDataAdapter(oCommand

oDA.Fill(oDs

oConn.Close(

bContinue = Fals
Catch ex As OracleExceptio
Throw e
Catch ex As Exceptio
Throw e
Finall
If Not (oConn Is Nothing) The
oConn.Dispose(
End I
End Tr

Return oD

CLIENT PROCES
sURI = String.Format("tcp://{0}:{1}/{2}.rem", "localhost", "6742", "SimpleData_DA"
oTest = CType(Activator.GetObject(GetType(OracleExceptionI nterfaces.BaseSimpleData_DA), sURI), OracleExceptionInterfaces.BaseSimpleData_DA
oTest.GetData(

We can provide simple client & server applications which demonstrate the problem
Nov 22 '05 #6
Tim -

Here are the answers to your question

1. We are using the 1.1 framework

2. When the debuging the "server side", the Server Exception i
? ex.tostrin
"System.Data.OracleClient.OracleException: ORA-00942: table or view does not exis

at System.Data.OracleClient.OracleConnection.CheckErr or(OciHandle errorHandle, Int32 rc
at System.Data.OracleClient.OracleCommand.Execute(Oci Handle statementHandle, CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals
at System.Data.OracleClient.OracleCommand.Execute(Oci Handle statementHandle, CommandBehavior behavior, ArrayList& refCursorParameterOrdinals
at System.Data.OracleClient.OracleCommand.ExecuteRead er(CommandBehavior behavior
at System.Data.OracleClient.OracleCommand.System.Data .IDbCommand.ExecuteReader(CommandBehavior behavior
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet
at OracleExceptionTest.SimpleData_DA.GetData() in C:\Starr\EBusiness.Net\Applications\OracleExceptio nTest\SimpleData_DA.vb:line 59

3. Here are the 2 pieces of code involvedâ€

SERVER PROCES
Tr

oDs = New DataSe
'Connecting to a valid Oracle D
oConn = New OracleClient.OracleConnection("Server=DWT.world;Ui d=leguser;Pwd=north01"
oConn.Open(
'The following lines cause an oracle exceptio
Dim oCommand As New OracleCommand("Select * from DWT.bob", oConn
oDA = New OracleDataAdapter(oCommand

oDA.Fill(oDs

oConn.Close(

bContinue = Fals
Catch ex As OracleExceptio
Throw e
Catch ex As Exceptio
Throw e
Finall
If Not (oConn Is Nothing) The
oConn.Dispose(
End I
End Tr

Return oD

CLIENT PROCES
sURI = String.Format("tcp://{0}:{1}/{2}.rem", "localhost", "6742", "SimpleData_DA"
oTest = CType(Activator.GetObject(GetType(OracleExceptionI nterfaces.BaseSimpleData_DA), sURI), OracleExceptionInterfaces.BaseSimpleData_DA
oTest.GetData(

We can provide simple client & server applications which demonstrate the problem
Nov 22 '05 #7
Tim -

Here are the answers to your question

1. We are using the 1.1 framework

2. When the debuging the "server side", the Server Exception i
? ex.tostrin
"System.Data.OracleClient.OracleException: ORA-00942: table or view does not exis

at System.Data.OracleClient.OracleConnection.CheckErr or(OciHandle errorHandle, Int32 rc
at System.Data.OracleClient.OracleCommand.Execute(Oci Handle statementHandle, CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals
at System.Data.OracleClient.OracleCommand.Execute(Oci Handle statementHandle, CommandBehavior behavior, ArrayList& refCursorParameterOrdinals
at System.Data.OracleClient.OracleCommand.ExecuteRead er(CommandBehavior behavior
at System.Data.OracleClient.OracleCommand.System.Data .IDbCommand.ExecuteReader(CommandBehavior behavior
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet
at OracleExceptionTest.SimpleData_DA.GetData() in C:\Starr\EBusiness.Net\Applications\OracleExceptio nTest\SimpleData_DA.vb:line 59

3. Here are the 2 pieces of code involvedâ€

SERVER PROCES
Tr

oDs = New DataSe
'Connecting to a valid Oracle D
oConn = New OracleClient.OracleConnection("Server=DWT.world;Ui d=leguser;Pwd=north01"
oConn.Open(
'The following lines cause an oracle exceptio
Dim oCommand As New OracleCommand("Select * from DWT.bob", oConn
oDA = New OracleDataAdapter(oCommand

oDA.Fill(oDs

oConn.Close(

bContinue = Fals
Catch ex As OracleExceptio
Throw e
Catch ex As Exceptio
Throw e
Finall
If Not (oConn Is Nothing) The
oConn.Dispose(
End I
End Tr

Return oD

CLIENT PROCES
sURI = String.Format("tcp://{0}:{1}/{2}.rem", "localhost", "6742", "SimpleData_DA"
oTest = CType(Activator.GetObject(GetType(OracleExceptionI nterfaces.BaseSimpleData_DA), sURI), OracleExceptionInterfaces.BaseSimpleData_DA
oTest.GetData(

We can provide simple client & server applications which demonstrate the problem
Nov 22 '05 #8
Hello,

Thanks a lot for your information. After further investigation, I noticed
this is a known issue in deserialization method of the
System.Data.OracleClient.dll.

I will send you another email for detailed information.

Regards,

HuangTM
Microsoft Online Partner Support
MCSE/MCSD

Get Secure! -- www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Nov 22 '05 #9
Hello,

Thanks a lot for your information. After further investigation, I noticed
this is a known issue in deserialization method of the
System.Data.OracleClient.dll.

I will send you another email for detailed information.

Regards,

HuangTM
Microsoft Online Partner Support
MCSE/MCSD

Get Secure! -- www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Nov 22 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Matthew Houseman | last post by:
All, I've created a synonym that points to a package over a database link like so: CREATE SYNONYM API_MYLINK FOR USER.CSAPI_V2@INSTANCE.DOMAIN.COM I've granted execute like so: grant execute...
0
by: J.Bijleveld | last post by:
Hello colleagues, At this moment we have a real big problem using a .NET application with an Oracle database (v8.1.6). I hope someone has encountered this problem before and is able to help me...
2
by: J.Bijleveld | last post by:
Hello colleagues, At this moment we have a real big problem using a .NET application with an Oracle database (v8.1.6). I hope someone has encountered this problem before and is able to help me...
8
by: Mike S. | last post by:
When we do remote calls to a component that throws a System.Data.OracleClient.OracleException, we see a SerializationException when the original OracleException is being deserialized on the client ...
0
by: dave v | last post by:
I thought I read in an earlier post that there are known issues with deserialization in the System.Data.OracleClient.dll. Can anyone expand on that or give a workaround? I'm calling a custom...
3
by: Nathan Sokalski | last post by:
I want to create a procedure in ASP.NET to run the "SET DEFINE OFF" command in an Oracle database. I tried the following: Public Shared Sub SetDefineOff() Dim myconnection As New...
1
by: Diffident | last post by:
Hello All, How can I throw an OracleException programmatically? What are the different constructors for this class? Thanks!!!
0
by: Chris | last post by:
I am getting the following exception when I try and connection to a remote oracle database. The same code works fine when I run it as an application. For the life of me I can't figure out why it...
5
by: jstmehr4u3 | last post by:
I just installed ODP.net 10.2.02 on my local machine (Windows XP Pro) running IIS. I have created a sample webservice in VS2003, connecting to localhost. I am getting:...
0
by: | last post by:
Hi All, I have a client connection problem with Oracle. The exe which i did with C# (vs.net 2005) and Oracle XE , works well on my developer machine but i am getting a connection string error on...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shćllîpôpď 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.