Re: Oracle UTL

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 27 Jul 2005 08:40:54 +0200
Message-ID: <dc7a9n$63d$1@news.BelWue.DE>

Sybrand Bakker wrote:
> On 26 Jul 2005 12:12:04 -0700, "Vic" <ruvic2004_at_gmail.com> wrote:
>
>

>>Im currently building a website and it will handle estimately 5,000
>>credit card transactions a day.
>>
>>Do you think its okay to use UTL_TCP to communicate to our credit card
>>server to send authorization request. Is there a limitation in terms of
>>number of sockets than can be opened from the Oracle DB since my site
>>can have simultaneous credit card auth request? Or maybe an issue if we
>>decide to use secure socket connection?
>>
>>What do you think?
>>
>>thanks,
>>Victor

>
>
> What I think is
> - Why do you posted this request 3 times in short succession?
> - I don't think this has anything to do with Oracle, but more with
> the TCP/IP implementation on your O/S, which you don't mention (so
> don't expect accurate responses)
> - IMO anything *NOT* involving SSL with respect to credit cards is
> simply out of the question. You don't want to expose your customers to
> credit card fraud, do you?
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

You really seem in a foul mood lately.

As he explores UTL_TCP, it sure has something to do with Oracle, too
He says *our* credit card server, so it might actually be two machines well protected behind the same firewall

To Victor:

I don't know what kind of communication between the database and the authorization server is taking place, but if I was you, I'd look into using java in the database. Under the covers, UTL_TCP is java anyway, (at least this was the case with earlier versions, this might have changed) so you might just as well use java directly, switching to secure sockets shouldn't be a problem as well.

Regards,
Holger Received on Wed Jul 27 2005 - 01:40:54 CDT

Re: Oracle UTL_TCP