Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 468
  • 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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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