• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • Last Modified:

consume web services on oracle

Hi experts, I developed a web service that connects to a stored procedure (package) that is in the oracle database, everything is OK, I see the web service data

The problem occurs when I want to eat go through a project in excel (VSTO)
shows only tables and views, shows no packages in order to select the stored procedure
attached images
vsSUDIO.JPG
dataSOURCEwizard.JPG
0
enrique_aeo
Asked:
enrique_aeo
  • 2
1 Solution
 
Padre_CorleoneCommented:
As far as i can tell you can only check items that are known to return a set of data.  If this is a stored procedure(s) that only returns data I could only recommend copying query to view.  Sorry i don't have much more on this.  Could not find anymore info.
0
 
enrique_aeoAuthor Commented:
I use the driver from microsoft or oracle?
0
 
Padre_CorleoneCommented:
should be the same driver as where you see tables and views, I imagine you are still usung oracle.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now