Solved

consume web services on oracle

Posted on 2010-09-13
3
455 Views
Last Modified: 2013-12-18
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
Comment
Question by:enrique_aeo
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
Padre_Corleone earned 500 total points
ID: 33763445
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
 

Author Comment

by:enrique_aeo
ID: 33778935
I use the driver from microsoft or oracle?
0
 
LVL 7

Expert Comment

by:Padre_Corleone
ID: 33779489
should be the same driver as where you see tables and views, I imagine you are still usung oracle.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question