Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL and signature
PL/SQL and signature [message #330253] Sat, 28 June 2008 04:18 Go to next message
st0ne
Messages: 3
Registered: June 2008
Junior Member
Hello

Sorry for my english Smile
It is necessary to process requests from POS-terminal.
According to communications protocol all request and response are signed. In PHP example for this use openssl_sign and openssl_verify functions. Are there analogs of this functions in PL/SQL? And if not, how resolve this problem?

Thanks in advance!
Re: PL/SQL and signature [message #330260 is a reply to message #330253] Sat, 28 June 2008 06:40 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
I don't think you want to look at PL/SQL for that. PL/SQL is the procedural data processing language. You need interaction on the network level.

The main question is, how does the POS terminal connect to the Oracle database? The normal listener? Some sort of web service?

For example, SSL encryption can be configured on the Listener level as described here by changing the entries in the listener.ora on the server and tnsnames.ora on the client, once Oracle Advanced Security is installed.

Have a look at the in the Advanced Security Administrator's Guide, Chapter 8, Configuring Secure Sockets Layer Authentication to see if that is what you are after.

Re: PL/SQL and signature [message #330262 is a reply to message #330260] Sat, 28 June 2008 07:32 Go to previous messageGo to next message
st0ne
Messages: 3
Registered: June 2008
Junior Member
ThomasG wrote on Sat, 28 June 2008 06:40

The main question is, how does the POS terminal connect to the Oracle database? The normal listener? Some sort of web service?



From communications protocol:

Data exchanging occur by means of HTTP. The Server give Client (POS-terminal) executable script available for client via Internet. The Client requests HTTP script by means of POST method with transmission of parameters of a bargain in the form of fields of POST-query. Client passes to the Server it's own IP address and RSA public key (digital signature)
Re: PL/SQL and signature [message #330266 is a reply to message #330253] Sat, 28 June 2008 08:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
FWIW - another thread yesterday was asking about doing POP3 over SSL.
I did a quick GOOGLE search on this topic.
I did not find any API for generic SSL interaction.
It appeared to me that some specific point solutions exist;
but I saw nothing that indicated anyone could roll their own protocol interaction inside SSL encapsultion.

It may exist & if it does, please post URLs back here.

Good Luck!
Re: PL/SQL and signature [message #330315 is a reply to message #330266] Sun, 29 June 2008 06:56 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:

Data exchanging occur by means of HTTP.



Then you need to enable HPPTS on the "middle tier" web server.
Re: PL/SQL and signature [message #339655 is a reply to message #330253] Fri, 08 August 2008 01:29 Go to previous message
st0ne
Messages: 3
Registered: June 2008
Junior Member
There is verify and sign functions in dbms_crypto_toolkit which work with RSA.
I try to execute example that describe in documentation , but it does not work and give error ORA-28759: failure to open file...
Can anyone help me in this problem?
Previous Topic: What leads to server crash?
Next Topic: Analytical function
Goto Forum:
  


Current Time: Sat Feb 08 20:49:33 CST 2025