Home » SQL & PL/SQL » SQL & PL/SQL » Websocket connection through Oracle PL SQL (Oracle 12c)
Websocket connection through Oracle PL SQL [message #668047] Thu, 01 February 2018 10:09 Go to next message
santoshvgotur@gmail.com
Messages: 1
Registered: February 2018
Junior Member
Hi Team,

There is a new requirement to connect to Websocket (wss://) from Oracle database using PLSQL code. Is there any way to connect wss:// websockets through PLSQL code . For SOAP webservice connection(h ttp://) i used the utl_http package , But didnot get enough source to connect wss connections.

I am trying to connect for websocket url like 'wss://host:port'.

I tried with UTL_TCP package but it is not setting the Target connections.

bt_conn := utl_tcp.open_connection(remote_host => 'sapsio.sap.com'
,remote_port => 80
, charset => 'AL32UTF8'
);

Could you please help me how can we connect websocket through PLSQL ?.

Thanks in advance.
Re: Websocket connection through Oracle PL SQL [message #668048 is a reply to message #668047] Thu, 01 February 2018 10:21 Go to previous messageGo to next message
BlackSwan
Messages: 26285
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

http://lmgtfy.com/?q=oracle+connect+to+websocket+example
Re: Websocket connection through Oracle PL SQL [message #668049 is a reply to message #668047] Thu, 01 February 2018 10:32 Go to previous messageGo to next message
Michel Cadot
Messages: 65980
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://www.opencodez.com/oracle/oracle-pl-sql-programming-socket-connection.htm

Re: Websocket connection through Oracle PL SQL [message #668059 is a reply to message #668047] Fri, 02 February 2018 06:54 Go to previous message
EdStevens
Messages: 1006
Registered: September 2013
Senior Member
santoshvgotur@gmail.com wrote on Thu, 01 February 2018 10:09
Hi Team,

There is a new requirement to connect to Websocket (wss://) from Oracle database using PLSQL code. Is there any way to connect wss:// websockets through PLSQL code
I find the logic of the question (apart from the "requirement" itself) to be somewhat problematic.

"There is a new requirement to do_item_a. Is there any way to do_item_a?"

Suppose the answer to the question is an emphatic "NO". Now, what happens to your "requirement"?

Be aware of the difference between a "requirement" (a business problem) and a pre-conceived technical solution.

Previous Topic: need two token matching query
Next Topic: dba_dependencies_columns
Goto Forum:
  


Current Time: Mon Nov 19 23:40:32 CST 2018