(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...)

In reply to Re: Perl connects/writes to Oracle using Oracle encrypted link by dHarry
in thread Perl connects/writes to Oracle using Oracle encrypted link by 2007fld

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.