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