OraFAQ Forum: SQL & PL/SQL » Websocket connection through Oracle PL SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Websocket connection through Oracle PL SQL (Oracle 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Websocket connection through Oracle PL SQL [message #668047]

Thu, 01 February 2018 10:09

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.

Report message to a moderator

Re: Websocket connection through Oracle PL SQL [message #668048 is a reply to message #668047]

Thu, 01 February 2018 10:21

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Websocket connection through Oracle PL SQL [message #668049 is a reply to message #668047]

Thu, 01 February 2018 10:32

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Websocket connection through Oracle PL SQL [message #668059 is a reply to message #668047]

Fri, 02 February 2018 06:54

EdStevens
Messages: 1377
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 16 11:13:09 CDT 2025