Re: Perl connects/writes to Oracle using Oracle encrypted link

(I haven't touched Oracle for some time so with the risk of BS-ing) It's a choice when you install the Oracle client. "Under water" the Oracle client is used for db communication. So if you change the settings to "encrypted connections" then your Perl connection will also be encrypted. The user/password are always encrypted (by default). After making the connection encrypted everything is encrypted

You can enable "client side tracing" (edit sqlnet.ora for this) to test if it is really working.

Hope this helps

Update

Stop the press, with ODBC it's a different story! What kind (brand) of ODBC driver do you use?

Update 2

Brother massa is right of course. See How do I encrypt network traffic to an Oracle instance? for additional information.

(The last time I played with this it was a JDBC connection to an Oracle 8 db which took some effort...)

Comment on Re: Perl connects/writes to Oracle using Oracle encrypted link

Replies are listed 'Best First'.
Re^2: Perl connects/writes to Oracle using Oracle encrypted link by massa (Hermit) on Aug 22, 2008 at 16:12 UTC
OP did not indicate to be using ODBC. Au contraire, `'dbi:Oracle:'` indicates the use of Oraperl (native Oracle bindings). Just one comment to the OP: don't do `my $info = "insert into table1 values('$user','$filename','$filesize', +'$time','$direction')"; my $sth = $dbh->prepare($info); $sth->execute();` [download] -- use instead either `my $info = "insert into table1 values (?, ?, ?, ?, ?)"; my $sth = $dbh->prepare($info); $sth->execute($user, $filename, $filesize, $time, $direction);` [download] or `my $info = "insert into table1 values(:user,:filename,:filesize,:time, +:direction)"; my $sth = $dbh->prepare($info); $sth->bind_param(user => $user); $sth->bind_param(filename => $filename); $sth->bind_param(filesize => $filesize); $sth->bind_param(time => $time); $sth->bind_param(direction => $direction); $sth->execute();` [download] (for various reasons, including security ones) []s, HTH, Massa (κς,πμ,πλ)	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^2: Perl connects/writes to Oracle using Oracle encrypted link
by massa (Hermit) on Aug 22, 2008 at 16:12 UTC

Au contraire

'dbi:Oracle:'

my $info = "insert into table1 values('$user','$filename','$filesize',
+'$time','$direction')";
my $sth = $dbh->prepare($info);
$sth->execute();
[download]

my $info = "insert into table1 values (?, ?, ?, ?, ?)";
my $sth = $dbh->prepare($info);
$sth->execute($user, $filename, $filesize, $time, $direction);
[download]

my $info = "insert into table1 values(:user,:filename,:filesize,:time,
+:direction)";
my $sth = $dbh->prepare($info);
$sth->bind_param(user => $user);
$sth->bind_param(filename => $filename);
$sth->bind_param(filesize => $filesize);
$sth->bind_param(time => $time);
$sth->bind_param(direction => $direction);
$sth->execute();
[download]

[]s, HTH, Massa (κς,πμ,πλ)

[reply]
[d/l]
[select]