RE: Call Oracle Procedure from Excel macro

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Also, there is a product from Oracle called "Oracle Objects for OLE". It's
downloadable form Oracle. It allows you to attach to the database and
retrieve data, change data, run procedures, etc.

I haven't actually used it to run procedures, yet, but it says that it can.

Here's a link to Oracle's description of it:

http://www.oracle.com/technology/tech/windows/ole/htdocs/OO4O_O9i_FO.html
.

Relevant Pages

  • sp_attach_db (encounted problems after having Oracle installed)...
    ... Cannot attach my database back to its ... I installed Oracle on my server a week ago, ... it's locking up every time I try to attach the ...
    (microsoft.public.sqlserver.connect)
  • Re: datareader reader questions
    ... where this field is a number in Oracle ... Mike ... >>I am trying to use a datareader to retrieve data and set some properties. ...
    (microsoft.public.dotnet.languages.csharp)
  • Retrieve Data from Oracle Database using BizTalk
    ... I am trying to retrieve data from oracle table using BizTalk oracle adapter. ... I have to use package for this project. ...
    (microsoft.public.biztalk.server)
  • Re: Connecting to Oracle with Access front end via VBA
    ... -Use SQL to retrieve data (then I loaded that data into an ADO ... recordset and closed the Oracle connection) ...
    (comp.databases.oracle.misc)
  • ORA-01426: numeric overflow
    ... In my code to retrieve data from Oracle using Microsoft ADO.NET Oracle ... Provider through System.Data.OracleClient.OracleConnection, I got ... numeric overflow while reading float datatype from Oracle. ...
    (microsoft.public.dotnet.framework.adonet)