Questions tagged [web-service]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
7 views

Accessing ORAWSV servlet via browser - Error 404 (NOT FOUND)

Based on the recommendations in the official Oracle documentation link below, I have activated the "orawsv" servlet. The servlet has been added successfully on the xdbconfig.xml file. The ...
0
votes
0answers
7 views

How can I publish a SOAP Web Service that takes data from an Oracle 12c Database?

I have an Oracle 12c Database. I want to extract data from this database and publish them via SOAP web services. I know to do this with REST web services (via ORDS and APEX utilities) but I find it a ...
0
votes
1answer
41 views

Oracle 11gR2 - Dynamic Registration

Database version: Oracle 11gR2 We want to use DYNAMIC_REGISTRATION_LISTENER parameter with off option. Our listener.ora file like this: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (...
1
vote
1answer
20 views

Is it good idea to invoke Web Service from the database function or trigger?

I am using PostgreSQL in my Web API project. I have created Web APIs using .net core. Now I have a situation, where I want to process the inserted or updated data and store the processed data in some ...
1
vote
0answers
17 views

How not to “naturalize” surrogate keys?

Don't naturalize surrogate keys. As soon as you display the value of a surrogate key to your end users, or worse yet allow them to work with the value (perhaps to search), you have effectively given ...
5
votes
1answer
232 views

System.Web in SQL Server CLR Function

I have done some light research into this topic and I would like to know what are all the pro's and con's or enabling/registering this particular .dll within SQL Server? Back information - we are ...
-2
votes
3answers
279 views

Is Oracle DBLink Vulnerable? [closed]

We have a web page on internet that calls a web service located on our intranet. The web service talks to Database A to get some data. Database A has a DBLink to Database B. This link is used to ...
1
vote
1answer
2k views

Running queries on a mirrored database

I have a Web forms asp.net site running with a database on a VM (VM1). I also have a MVC 5 Web app that has its own membership database on another VM (VM2). I want to retrieve customer information ...
1
vote
1answer
278 views

SQL Server Web Service in a web environment architecture

I am new at SQL Server web Service and not too knowledgeable in setting up a secure web environment... From what I've read until now regarding SQL Web Service, I would need to: 1. create a stored ...
2
votes
1answer
241 views

How to store search keyword or browsing history in database [closed]

I'm making my final year project. Which is a website. Things I can't do: Store the browsing history of users between their login and logout session on the site. Or Store the search keywords. But I ...
0
votes
1answer
133 views

SQL Server: Mixed mode security: Can a non AD user (a local user, remote client) have a trusted connection to SQL?

I have used SQL Server trusted connections for years. It works well when the client app is a domain user. Imagine this three server config: dbserver webserver domain controller I now have a ...
0
votes
1answer
3k views

Calling a web service from T-SQL (Stored Procedure) using MSXML [closed]

EXEC @hResult = sp_OAMethod @objectID, 'send', null, @requestBody IF @hResult <> 0 BEGIN EXEC sp_OAGetErrorInfo @objectID, @source OUT, @desc OUT SELECT ...
2
votes
1answer
180 views

Audit use of CLR Table-valued function

I have written some CLR table-valued functions that invoke a web service and I would like to audit their use. Does anyone know of any way this can be achieved in the CLR code itself? I would be nice ...
4
votes
1answer
3k views

Bringing web service data into SQL server

I need to retrieve a data set daily from a hosted Web service. I can retrieve the XML "column names" in an SSIS package. But I need to retrieve all the data in the data set in csv format or bring ...
9
votes
4answers
3k views

How to get response from stored procedure before it finishes?

I need to return partial result (as simple select) from a Stored procedure before it is finished. Is it possible to do that? If yes, how to do that? If not, any workaround? EDIT: I have several ...
3
votes
2answers
971 views

SQLCLR TVF that calls web service is getting error 401: Unauthorized

I am calling a web service from a SQLCLR TVF in SQL Server 2008 R2. On the IIS server this service has open permissions. When tested using GET or POST requests on a browser the web service works as ...