| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Executing PL/SQL in Excel
Hi, Anyone know if it is possible to execute Oracle PL/SQL code from within Excel VBA code? Thanks. -- scos00 ------------------------------------------------------------------------ scos00's Profile: http://www.excelforum.com/member.php...o&userid=28264 View this thread: http://www.excelforum.com/showthread...hreadid=491805 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Executing PL/SQL in Excel
Use ADO.
Create an ADO.Connection, connect to your Oracle database and use Connection.Execute strPLSQL Does your code return any records or values? Does it take any parameters? Tim -- Tim Williams Palo Alto, CA "scos00" wrote in message ... Hi, Anyone know if it is possible to execute Oracle PL/SQL code from within Excel VBA code? Thanks. -- scos00 ------------------------------------------------------------------------ scos00's Profile: http://www.excelforum.com/member.php...o&userid=28264 View this thread: http://www.excelforum.com/showthread...hreadid=491805 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Executing PL/SQL in Excel
So it is possible? That's great if I can get it working it will do exactly what I want. Yes I will need to pass 1 parameter to the stored procedure and then capture a set of records later but this won't be in the return value. What I want to do is pass the parameter to a procedure/function, then the function will create records in a table. Then I want to read the data from the table and drop it into a worksheet. I have used the ADO connection before so I will try to dig out the syntax now.... Thanks! -- scos00 ------------------------------------------------------------------------ scos00's Profile: http://www.excelforum.com/member.php...o&userid=28264 View this thread: http://www.excelforum.com/showthread...hreadid=491805 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Executing PL/SQL in Excel
GREAT! Got it working with a simple procedure. Now I need to see if I can get it working with a function - how do I capture the return value?? -- scos00 ------------------------------------------------------------------------ scos00's Profile: http://www.excelforum.com/member.php...o&userid=28264 View this thread: http://www.excelforum.com/showthread...hreadid=491805 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Executing PL/SQL in Excel
Right, I created a wrapper procedure to call the DB function so I don't need to capture the return value (may add this later if someone can help me out). The only problem I have left now is that after executing the procedure and fetching the data into the worksheet I lose focus from Excel completely and have to manually select it from the Windows toolbar - bizarre??! any ideas? Thanks. -- scos00 ------------------------------------------------------------------------ scos00's Profile: http://www.excelforum.com/member.php...o&userid=28264 View this thread: http://www.excelforum.com/showthread...hreadid=491805 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Executing a bat file from Excel | Excel Worksheet Functions | |||
| Executing of excel Macros. | Excel Discussion (Misc queries) | |||
| Executing sub procedure when Excel starts | Excel Programming | |||
| Executing an older excel 4.0 macro | Excel Programming | |||
| Excel VBA code executing a variable as a Sub. | Excel Programming | |||
![scos00[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
