PL/SQL and signature [message #330253] |
Sat, 28 June 2008 04:18  |
st0ne
Messages: 3 Registered: June 2008
|
Junior Member |
|
|
Hello
Sorry for my english
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   |
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   |
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 #339655 is a reply to message #330253] |
Fri, 08 August 2008 01:29  |
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?
|
|
|