how to call a web page through stored procedure

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

SQL-Server

I want to call an url through Stored procedure. how can i do it?

Posted 22-May-12 23:34pm

Bhavana P

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manfred Rudolf Bihy · Answer 1 · 2012-05-23T00:21:00

Solution 2

You may not want to hear this advice, but here it goes nevertheless: Don't do this. Stored procedures should handle data and the processing thereof on the SQL Server. Retrieving remote data from a website in a store procedure is calling for all kinds of trouble: Performance, Transaction contention, Non-Determinism etc.. If you absolutely need some external data, fetch it beforehand and pass it along to the SP in the call you are making.

My two cents!

Regards,

Manfred

Posted 23-May-12 0:21am

Manfred Rudolf Bihy

Comments

Bhavana P 23-May-12 8:24am

Thank you Sir ,
for the reply , but its my requirement to call an url through SP , I will get back to you after working on it.

Manfred Rudolf Bihy 24-May-12 5:02am

Can you tell us about your specific requirement? I would be very interested if this couldn't be solved by a better fitting scenario.

Regards,

Manfred

Bhavana P 24-May-12 5:55am

Sir, I have tried it using COM objects , I have refered mentioned in the solution below.

Wendelius 23-May-12 16:21pm

Fully agree!

Prasad_Kulkarni · Answer 2 · 2012-05-23T00:07:00

Solution 1

Please refer some similar discussions:

Send a URL request from a stored procedure[^]
Calling a URL from a stored procedure[^]
How to execute a url in tsql stored procedure[^]

Posted 23-May-12 0:07am

Prasad_Kulkarni

madhusudhan.k · Answer 3 · 2012-05-23T03:09:00

Solution 3

Try this:

SQL

exec master..xp_cmdshell 'c:\progra~1\intern~1\iexplore.exe www.xyz.com'

Change the path to iexplore.exe as per your machine setup

Posted 23-May-12 3:09am

madhusudhan.k

Updated 23-May-12 3:12am

v2

Bhavana P · Answer 4 · 2012-05-23T23:49:00

Solution 4

This is one of the way I have worked on ,
using COM objects from T-SQL the url is invoked :
First an instance of OLE object is created by using Sp_oacreate then
second method of the web page execution is defined using Sp_oamethod
third the object is destroyed using Sp_oadestroy
It works ...!

Posted 23-May-12 23:49pm

Bhavana P

Comments

Prasad_Kulkarni 25-May-12 2:06am

Don't re-post your answers Princess, use 'Improve solution' widget if you want to add or modify your solution.

Bhavana P 25-May-12 2:27am

OK Sir, I will implement now onwards.

Bhavana P · Answer 5 · 2012-05-24T20:01:00

This is one of the way I have worked on ,
using COM objects from T-SQL the url is invoked :
First an instance of OLE object is created by using Sp_oacreate then
second method of the web page execution is defined using Sp_oamethod
third the object is destroyed using Sp_oadestroy
It works ...!

The @url includes the url to be fetched from a table.

SQL

SET @random=(SELECT CAST(CAST(Rand() * 12000000 AS INT) AS VARCHAR))
                    SET @NAME=@URL + '&randomid=' + @random
					
                    EXEC Sp_oacreate
                      'MSXML2.XMLHTTP',
                      @Object OUT;

                    EXEC Sp_oamethod
                      @Object,
                      'open',
                      NULL,
                      'get',
                      @NAME,
                      'false'

                    EXEC Sp_oamethod
                      @Object,
                      'send'

                    EXEC Sp_oamethod
                      @Object,
                      'responseText',
                      @ResponseText OUTPUT
                     
                    EXEC Sp_oadestroy @Object