Hi I am using the Microsoft .NET Provider for Oracle found in
System.Data.OracleClient.

For some reason OracleDataAdapter.Fill NEVER works (I tried it with
many different queries), it always throws an exception.

code snippet:

Dim comm As OracleCommand = Connection.CreateCommand
Dim tbl As New DataTable
Dim adapter As New OracleDataAdapter

comm.CommandText = "Select * from Test"
adapter.SelectCommand = comm

Connection.Open()
adapter.Fill(tbl)
Connection.Close()


"An unhandled exception of type
'System.Data.OracleClient.OracleException' occurred in system.data.dll
Additional information: System error."

not much help. if i add a watch on the exception, here is ex.message:
"OCI-22053: overflow error"

There is no other useful help, no other inner exceptions.

Note that this error message occurs with ANY SQL Statement I try.

Using the other objects in System.Data.OracleClient have given me no
problems; I have used DataReaders, Command.ExecuteNonQuery without
issues.

FYI: I have VS2003, .NET FW 1.1, OraClient 8.1.7.

Hi Cip,

Try few things:
Dim comm As new OracleCommand instead of connection.createcommand
Within select try selecting just one field.

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Cip" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi I am using the Microsoft .NET Provider for Oracle found in
> System.Data.OracleClient.
>
> For some reason OracleDataAdapter.Fill NEVER works (I tried it with
> many different queries), it always throws an exception.
>
> code snippet:
>
> Dim comm As OracleCommand = Connection.CreateCommand
> Dim tbl As New DataTable
> Dim adapter As New OracleDataAdapter
>
> comm.CommandText = "Select * from Test"
> adapter.SelectCommand = comm
>
> Connection.Open()
> adapter.Fill(tbl)
> Connection.Close()
>
>
> "An unhandled exception of type
> 'System.Data.OracleClient.OracleException' occurred in system.data.dll
> Additional information: System error."
>
> not much help. if i add a watch on the exception, here is ex.message:
> "OCI-22053: overflow error"
>
> There is no other useful help, no other inner exceptions.
>
> Note that this error message occurs with ANY SQL Statement I try.
>
> Using the other objects in System.Data.OracleClient have given me no
> problems; I have used DataReaders, Command.ExecuteNonQuery without
> issues.
>
> FYI: I have VS2003, .NET FW 1.1, OraClient 8.1.7.

I am getting the same error, although in my case I have been able to
find where the problem starts.
The error occurs when retrieving an OracleNumber that is outside the
allowable range: (+-)79,228,162,514,264,337,593,543,950,335.

msdn includes the following remarks for the OracleNumber.Value
property:
If you attempt to retrieve a value outside the allowable range, Oracle
returns the "OCI-22053: overflow error" message. Use the ToString
method to retrieve such values.

Unfortunately I have not yet worked out how to get around this while
still using the Fill method but if I do, I will post it.

Note: I am using VS2003, .NET FW 1.1, Oracle9i


Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com