开发者

Oracle error 3113

I'm developing a VS2008 desktop application, this application makes 2 connections, one to an access database and other to an oracle database. I can connect to both databases just fine but, when I'm trying to get a datatable from oracle, the application crashes throwing a ORA03113 error.This only happens when I call the Fill method of my OracleDataAdapter object.

I don't know how to fix this error, when I execute the same query in SQL Developer it works just fine.

Thanks.

UPDATE:

I can't show you the connections string, but it can open a connection just fine.

The code is pretty standard:

Imports Oracle.DataAcces开发者_运维百科s.Client

Dim info as Datatable = new Datatable
Dim adapter as OracleDataAdapter("Select * From userinfo ui Where ui.userid = 13", conn)
adapter.Fill(info)

The error shows up at adapter.Fill()


What happens when you do not connect to the access database? What happens if you use a different data table, such as DUAL, which has only a single row and single column named 'X'?

ORA-03113 is a catch-all "Well, I was connected but now I'm not" error. http://dba-oracle.com/m_ora_03113_end_of_file_on_communications_channel.htm

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜