Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default calling an oracle function from Excel


Hi,

i don't know if this is the right place to make this question, but i'm
like desperate, so it goes.

first the big pictu
I have an Excel application that has to read some data (input from the
user) and then create a xml document and pass it to some oracle stored
function so that can be inserted in a table. And in the other hand an
oracle stored function has to query data from a table, create a xml
document and then pass it to Excel Application so that data can be
stored in the Excel.

The oracle functions are done, so are the Excel part. The BIG problem
here is how to the communication between them, i tried connecting to
oracle through ODBC and call the stored procedures, but no success, i
tried with ADODB, but with that i can't even establish a connection to
the Oracle Database. I also tried with sqlplus, and even if i can call
a procedure with sqlplus i don't know how to call a function and how to
retrieve it's results to Excel.

Any help or redirection information would be very appreciated, because
like i said, i'm kind a desperate and alone in here.

Thanks,


--
Jlorga
------------------------------------------------------------------------
Jlorga's Profile: http://www.excelforum.com/member.php...o&userid=31707
View this thread: http://www.excelforum.com/showthread...hreadid=518633

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calling Oracle Stored Procedure Jim Heavey Excel Programming 3 February 10th 06 02:24 AM
calling a new function Excel gives me #NAME? Mark Dvorkin Excel Worksheet Functions 4 July 10th 05 01:29 AM
Calling of simple function in Excel 97 TomCee Excel Programming 3 April 20th 04 02:44 PM
Calling Word function from within Excel Ed[_9_] Excel Programming 1 September 17th 03 11:47 PM
Calling a function from within EXCEL pcor[_2_] Excel Programming 3 July 18th 03 05:10 PM


All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"