RE: Call Oracle Procedure from Excel macro
- From: quartz <quartz@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 6 Jun 2005 13:19:18 -0700
I can't answer all of your questions for Oracle, but I have successfully done
this with PeopleSoft using ADO. I hope the following will set you on track
for looking at the appropriate arguments at least:
Set ADO "CommandText" to your stored procedure name and then set the
"CommandType" to "adCmdStoredProc"
e.g:
cnADO.CommandText = myStoredProcedureName
cnADO.CommandType = adCmdStoredProc
You don't specify if you are returning records or not; my example returns
records. So your code might look something like:
Dim adoCM As ADODB.Command
Dim adoCN As ADODB.Connection
Dim adoRS As ADODB.Recordset
Set adoCN = New ADODB.Connection
adoCN.CursorLocation = adUseClient
adoCN.Properties("Prompt") = adPromptComplete '<this is for logon not param
adoCN.Open "ODBC;YOUR_ConnectionString_for_Oracle;"
Set adoCM = New ADODB.Command
Set adoCM.ActiveConnection = adoCN
adoCM.CommandText = YourProcedureName
adoCM.CommandType = adCmdStoredProc
'Run query and populate a recordset
Set adoRS = New ADODB.Recordset
Set adoRS = adoCM.Execute
In PeopleSoft I was able to build-in the prompts into the stored procedure
on the PeopleSoft side, I don't know how to do that for Oracle or if you even
can...
HTH somehow.
"test" wrote:
> Hi ALL
> I need to call a Oracle Procedure from Excel Macro?
> Does anybody know How to do it?
> Any code samples?
> My procedure has 5 IN parameters and 1 OUT parameter.
> I was thinking of using ODBC to connect to the database.
> Please help...........urgent.........
> Thanks
>
>
>
.
- References:
- Call Oracle Procedure from Excel macro
- From: test
- Call Oracle Procedure from Excel macro
- Prev by Date: Re: DeleteDuplicateRows: problem with this macro
- Next by Date: Date Format Changes on Copy
- Previous by thread: Call Oracle Procedure from Excel macro
- Next by thread: RE: Call Oracle Procedure from Excel macro
- Index(es):
Relevant Pages
|
