Home » SQL & PL/SQL » SQL & PL/SQL » open a URL using Oracle Pl/Sql (merged 3)
open a URL using Oracle Pl/Sql (merged 3) [message #418757] Tue, 18 August 2009 08:54 Go to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
Hi Friend's,

Can anybody help me ,to open a URL using Oracle Pl/Sql.I want to write a Pl/SQL code that will open a Webpage after execution. Please help me ..

Regards,
Re: open a URL using Oracle Pl/Sql (merged 3) [message #418764 is a reply to message #418757] Tue, 18 August 2009 09:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL does not interact with client, "open a web page" is meaningless for PL/SQL.
Explain in details what you want to do, from what and so on.

Regards
Michel
Re: open a URL using Oracle Pl/Sql (merged 3) [message #418765 is a reply to message #418764] Tue, 18 August 2009 09:08 Go to previous messageGo to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
Suppose I want to open http://www.orafaq.com in my client system.Is there any script available for that ?
Re: open a URL using Oracle Pl/Sql (merged 3) [message #418767 is a reply to message #418757] Tue, 18 August 2009 09:09 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Suppose I want to open http://www.orafaq.com in my client system.Is there any script available for that ?


It is called a web browser

[Updated on: Tue, 18 August 2009 09:09]

Report message to a moderator

Re: open a URL using Oracle Pl/Sql (merged 3) [message #418768 is a reply to message #418757] Tue, 18 August 2009 09:10 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Depends on your client system.
PL/SQL is not relevant here.
Re: open a URL using Oracle Pl/Sql (merged 3) [message #418769 is a reply to message #418768] Tue, 18 August 2009 09:12 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
And it depends on where you all the pl/sql from.

For example, if it's a unix shell script or a windows batch file, then you can open the web page from the unix script or window batch after the database call.
Re: open a URL using Oracle Pl/Sql (merged 3) [message #418770 is a reply to message #418767] Tue, 18 August 2009 09:12 Go to previous messageGo to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
Yes.It is a web browser like Internet explorer.
Re: open a URL using Oracle Pl/Sql (merged 3) [message #418778 is a reply to message #418767] Tue, 18 August 2009 09:22 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
BlackSwan wrote on Tue, 18 August 2009 16:09
>Suppose I want to open http://www.orafaq.com in my client system.Is there any script available for that ?


It is called a web browser

LOL
Re: open a URL using Oracle Pl/Sql (merged 3) [message #418780 is a reply to message #418769] Tue, 18 August 2009 09:22 Go to previous messageGo to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
How to to do that? Can you provide any sample code ?
Re: open a URL using Oracle Pl/Sql (merged 3) [message #418781 is a reply to message #418757] Tue, 18 August 2009 09:25 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>How to to do that? Can you provide any sample code ?
GOOGLE or SEARCH for UTL_HTTP

Good Luck reinventing the web browser!

[Updated on: Tue, 18 August 2009 09:25]

Report message to a moderator

Re: open a URL using Oracle Pl/Sql (merged 3) [message #418783 is a reply to message #418780] Tue, 18 August 2009 09:27 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
subhadip.chanda wrote on Tue, 18 August 2009 16:22
How to to do that? Can you provide any sample code ?


Sample code for what OS and what scripting language?
Re: open a URL using Oracle Pl/Sql (merged 3) [message #418785 is a reply to message #418780] Tue, 18 August 2009 09:32 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1224436374644

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:285215954607

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:676704700346528359
Previous Topic: Spool + user defined cells
Next Topic: Trunc Creating Problem
Goto Forum:
  


Current Time: Sat Dec 10 05:03:16 CST 2016

Total time taken to generate the page: 0.20245 seconds