Solved

consume web services on oracle

Posted on 2010-09-13
3
453 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Cannot upload files above 1mb IIS7 11 39
Class object 2 26
Syntax error 9 45
Replace &lt; with < 14 54
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

919 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now