尝试检索错误ora-01019的文本时出错 [英] Error while trying to retrieve text for error ora-01019

问题描述

我有一个excel，我们使用VBA检索oracle数据库数据。它正在Windows 7上工作，但现在系统升级到Windows 10.升级后我们面临运行时ora-01019错误。



错误：运行时错误 -2147467259（80004005）'：尝试检索错误ORA-01019的文本时出错



请帮忙。



我尝试过：



我尝试安装32位和64位的Oracle客户端驱动程序。现在我已经安装了32位驱动程序。

Hi,

I have one excel in which we retrieve oracle database data using VBA. It was working on windows 7 but now systems are upgraded to windows 10. After upgradation we are facing runtime ora-01019 error.

Error: "Run-time error '-2147467259 (80004005)': Error while trying to retrieve text for error ORA-01019"

Please help.

What I have tried:

I tried installation on of Oracle client drivers 32 bit and 64 bit. now I have installed on 32 bit drivers.

推荐答案

如果你收到一条你不明白的错误信息，谷歌吧：运行时错误'-2147467259（80004005）'：尝试检索错误的文本时出错ORA-01019 - Google搜索 [ ^ ]如您所见，可能性很大......

If you get an error message you don't understand, Google it: Run-time error '-2147467259 (80004005)': Error while trying to retrieve text for error ORA-01019 - Google Search[^] as you can see, loads of possibilities...

您有两个错误：

首先，您从数据库驱动程序中获得了ORA-01019（无法在用户端分配内存）。然后，当您尝试获取数据库错误消息时，您有一个0x80004005（ E_FAIL =发生未确定的错误）错误。



快速搜索ORA错误： ORA-01019 [ ^ ]



修复数据库错误后你还应修复第二个错误一。您可能有一个尝试获取并显示错误消息的函数。在那里你应该捕获失败并显示一个适当的消息，如无法获取[Oracle错误代码]的错误消息文本。

You have two errors:
At first you have an ORA-01019 ("unable to allocate memory in the user side") from the database driver. Then you have a 0x80004005 (E_FAIL = "An undetermined error occurred") error when trying to get the database error message.

A quick search for the ORA error: ORA-01019[^]

After fixing the database error you should also fix the second one. You have probably a function that tries to get and show the error message. There you should catch the failure and show an appropriate message like "Unable to get error message text for [Oracle error code]".

最后很多R和DI发现了我自己的灵魂，这只不过是一个VBA项目参考。



VBA窗口 - >工具 - >参考文献 - >并检查OracleDataControl，OraOLEDB 1.0类型库

现在它正常工作

Hi,

Finally lot R and D I found soultion my self and that is nothing but a VBA Project ref.

VBA Window -> Tools -> References -> and check OracleDataControl, OraOLEDB 1.0 Type Library
Now its working fine

这篇关于尝试检索错误ora-01019的文本时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！