Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel to call Oracle Stored procedure.
I am trying to get Excel/MSQuery to call an Oracle stored procedure and
return a record set. Every time I try it I get an access violation error. Is there a way to call an Oracle stored procedure (or function) and return a record set to excel? Thanks. -- Thanks for the Memory. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel to call Oracle Stored procedure.
in vba i use the following to read from SQL server change the provider "MSDASQL" to whatever is appropriate for Oracle also change servername, databasename ans stored_proc_name appropriately Dim rst As ADODB.Recordset Dim db As Connection Dim SQL As String Dim i As Long Set db = New Connection With db .CursorLocation = adUseClient .Open "PROVIDER=MSDASQL;driver={SQL Server};server=SERVERNAME=;pwd=;database=DATABASEN AME;" End With Set rst = New Recordset SQL = "STORED_PROC_NAME" rst.Open SQL, db, adOpenStatic, adLockOptimistic range("B5").CopyFromRecordset rst "pdcjlw1" wrote in message ... I am trying to get Excel/MSQuery to call an Oracle stored procedure and return a record set. Every time I try it I get an access violation error. Is there a way to call an Oracle stored procedure (or function) and return a record set to excel? Thanks. -- Thanks for the Memory. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best way to call a SQL Server Stored Procedure from within Excel | Excel Programming | |||
How can Oracle DB Stored procedure be called in MS Excel? | Excel Discussion (Misc queries) | |||
Calling Oracle Stored Procedure | Excel Programming | |||
Returning a resultset from Oracle Stored Procedure using ADO (VBA) | Excel Programming | |||
Call Oracle Procedure from Excel macro | Excel Programming |